India: +91 406677 1418

WhatsApp no. : +919100386313

USA: +1 909 233 6006

Telegram : +15168586242

SAP HANA MODELING Training

SAP HANA Modeling Training Course Introduction :

SAP HANA Modeling is an Information Models (SAP HANA Views) are optimized for SAP HANA Engines and Calculation Operators. Data/Columns are classified as Attributes or Measures in SAP HANA Views. SAP HANA Modeling Calculation Views provide the means to model sophisticate views based on normalized data structures. SAP HANA Modeling Training at Global Online Tranings provides Knowledge on Complex Calculation Views demand a more explicit intent and control of the modeled set-based data flow, i.e. slicing, aggregation and filtering of sets as input to joins, unions.

SAP HANA MODELING Training Course Content

SAP HANA Modeling Training Part1SAP HANA Modeling Training Part2

What is SAP HANA Modelling Training?

Data Modelling is basically converting source data into a meaningful  user or business understandable data. Modelling is the process of applying business logic or applying transformation and integrating data between different systems into a single platform.

Advantages of SAP HANA Modelling Training:

  • Whatever the business logic or data models we create in SAP HANA MODELING Training ,everything will run on the fly. Usually if we take any other platform we use to create lot of phases or lot of layers. For example, we use to call first layer as data staging where we get all the source data into data ware housing platform and then we apply the transformations and store it into a different place where we call that as a transformation phase and then apply few more transformations and store it in reporting phase which can be accessed by different reporting tools. However, when it comes to SAP HANA MODELING Training we don’t need to store data multiple times.so we can apply all the business transformations on the fly using different HANA models available in SAP HANA MODELING Training.
  • We have different engines available which can be used to execute modelling objects which we create at HANA level and HANA also has lot of new hardware innovations like parallel processing and then HANA has multi CPU architecture. So if we build those modelling objects at HANA level itself then whenever we execute those modelling objects those objects can use the multi cpu architecture as well as parallel processing and then the analytical engines available at HANA level.

Overview of SAP HANA Modelling Training :

Types of Modelling Objects:

Using this 4 different modelling objects we can apply most of the business transformations or business logic inside SAP HANA MODELING Training itself. Advantage of using this modelling objects is when we apply all this transformations at database level itself, so what we are doing here is, we are trying to reduce data transfer between database and  reporting application.

Attribute view:

The attribute view is to build a model and entity which is based on the multiple sources. It is heavily optimized of processing the joins between multiple tables. Here we can also have calculated columns we can write formulas by the calculated columns as the business logic at an application server layer, we can push down the code into HANA itself.We can also have hierarchies, to see all the data for the company, for that company code you can define the hierarchy within your views as well.In the SAP HANA MODELING Training, the basic process of building the attribute view, we need to add one or more tables as the source and then these tables will show up. If you want to combine the measures that are originating from number of tables or calculation view, you can join these tables. And you shouldn’t use join to address this requirement, it is very costly. It is more beneficial to use a union node as it provides much better performance. And here the union is not a join type.

Analytic view:

Analytic view is basically a star model or star schema. Where star schema holds a single transaction table which is surrounded by multiple dimensions in SAP HANA MODELING Training. That is the reason whenever we create an analytic view we cannot have measures from more than one table in analytic view and then once you select what are the elements you need from  transaction table or fact table you can join that transaction table with required dimensions which means with required attribute views.

Calculation view:  

We have to apply Calculation view  for more advanced business logic.We have complex transformations like combining two different transaction data.Global Online trainings  is rich in offering SAP HANA MODELING Online training by best trainers.

Decision tables:

These are basically for business purpose mostly for planning purpose where a lot of if and else conditions because whenever an organization has to do something on either it can be offering some promotions due to some events they do lot of planning like for so and so discount then what is going to be the effect on revenue and is it good to give this much percentage of discount or not ,so they do all this planning which means they apply lot of if and else conditions. All this if else analysis can be easily created using graphical user interface with the help of decision tables.

 

 

Online Trainings
Review Date
Course
SAP HANA Modeling Training
Rating
51star1star1star1star1star