Sap Hana Modeling
SAP HANA Modeling is an activity by which we create
information view. Information View is similar to dimension, cube or information
provider of BW. This information view is used for creating the
multi-dimensional data model.
SAP HANA Modeling Overview
Modelling
is an activity in which user refine or slice data in the database table by
creating information view based on the business scenario. This information
views can be used for reporting and decision-making purpose.Information view is
made from various combinations of content data to create a model for a business
scenario.
Modeling SAP HANA Information Views are important for successfully exploiting the power
of SAP HANA. These views are classified as
- Attribute Views
- Analytic Views
- Calculation Views
Attribute View:
- Attribute views are dimensions, BW characteristics or master data.
- Attribute views are used to join to a dimension or attribute view.
- In most cases used to model master data like entities (like Product, Employee, Business Partner)
- Highly re-used and shared in Analytic- and Calculation Views
Analytic View:
- Analytic views are star schemas or fact tables surrounded by dimensions, calculations or restricted measures.
- In the language on SAP BW analytical views can be roughly compared with Info Cubes or Info Sets.
- Analytic views are typically defined on at least one fact table that contains transactional data along with number of tables or attribute views.
- Analytic views leverage the computing power of SAP HANA to calculate aggregate data, e. g., the number of bikes sold per country, or the maximum power consumed per month.
- It is specifically designed to execute star schema queries
Calculation View:
- Calculation views are composite views used on top of analytical and attribute views.
- It can perform complex calculations not possible with other views.
- It can be defined as either graphical views or scripted views depending on how they are created. Graphical views can be modeled using the graphical modeling features of the SAP HANA Modeler. Scripted views are created as sequences of SQL statements.
- Calculation views can be referred as combination of tables, attributes views and analytical views to deliver a complex business requirement. They offer to combine different analytical views into one source of data for reporting.
