Sap Hana - All About Views (ePub)

SAP HANA Modeling is one of the key capabilities of HANA system. This allows to create multidimensional objects on top of HANA database objects to meet the business requirements for reporting. You can implement complex business logic using HANA information models to create a meaningful report for analysis.

Features of HANA Modeling

SAP HANA Modeling is one of the key concepts in HANA BI reporting.

Using HANA Modeling, you can create complex data models as per business requirement to provide multiple views of transactional data stored in physical tables of HANA database.

SAP HANA Modeling can only be done for column-based storage tables.

HANA Modeling views can be used directly by SAP BusinessObjects reporting tools such as Crystal Reports or Lumira using an OALP or HTTP connection.

HANA supports different types of Modeling views such as - Attribute view is used to model characteristics, Analytic view is used to implement Star schema and Calculation view is used to implement complex logics, which are not possible with other type of views (Galaxy schema).

SAP HANA Modeling views can also be directly connected to third party tools such as MS Excel using HANA MDX Provider.

SAP HANA Modeling supports various features of Business Layer - Creating new calculated columns, new measures, input parameters, hierarchies, etc.

SAP HANA provides following three types of Information Views −

Attribute View

Analytic View

Calculation View