HANA Modeling

What is SAP HANA Modeling?

Modeling in SAP HANA showcases data from database as a business logic or a model. We can create a data model or a view with this business logic, which we can use in reporting and analytical application like  SAP Lumira, Webi, SBEE, MS Excel etc. We can make this kind of business models by processing, integrating and transforming raw data from data sources.

That is, raw data taken from data sources is converted into business utilizable data by applying business logic on it. SAP HANA modeling is performed via the SAP HANA Studio Modeler (which is an interface) and is applied directly on the database layer (in-memory). Thus, readymade logics from the database layer of SAP HANA are used on the application layer without transforming data in multiple layers or stages. This saves a lot of system’s time and resources, as raw data is not needed to be transferred between the database and application layer and data models, are created on the fly.

We can create modeling tools in the modeler, in which a data will process from the database according to blueprint offered by the data model. The models create on the HANA database level utilize the processing potentials of multi-core CPUs and parallel processing technologies, which we can execute by the dedicated engines in SAP HANA.

We can create a SAP HANA data model in the modeler perspective of the SAP HANA Studio. You can access the database and tables as the schemas present under the Catalog tab. Once you have created a business model having a combination of information views in it, you can access the entire list of views as a package in the Content tab present in the system view section of the Studio. These SAP HANA information model views reside under a package name as categories based on view types. Also, within a view, the data tables are structured differently as dimension tables and fact tables.

Know more about SAP.




50 Days of Instructor-Led Training.