SAP HANA Modeling

SAP HANA Modeling techniques are enabled in the SAP HANA System with the help of a component known as SAP HANA modeler. This component is used for creating various information views above tables in the SAP HANA database. JAVA/HTML based applications or SAP Applications like SAP Lumira, Office Analysis or third party software like MS Excel are used for consuming these information views for various reporting purposes and helps the organization meet business logic and to perform analysis and  information extraction.

Overview of HANA Modeling

The SAP HANA Information Modeling is also known as SAP HANA Data Modeling and it is an important part of SAP HANA Application development. By creating modeling views over the database tables, the HANA modeler enables the generation of meaning full reports at easier access. HANA Modeling is done on the top of tables available in Catalog tab under Schema in HANA studio and all views are saved under Content table under Package. These packages can be created by the user on right clicking on the Content and New under the Content Tab in SAP HANA studio. All Modeling Views created inside one package comes under the same package in HANA studio and categorized according to View Type. Each View has a different structure for Dimension and Fact tables. Dim tables are defined with master data and Fact table has Primary Key for dimension tables and measures like Number of Units sold, Average delay time, Total Price, etc.

Fact and Dimension Table – This table contains Primary Keys for the dimension table and measures. These primary keys help the tables to be joined in HANA views while meeting various business logics. Dimension Table contains master data and is joined with one or more fact tables to make some business logic. Dimension tables are used to create schemas with fact tables and can be normalized. For instance, if an organization is producing products and selling it to customers, each and every sale is a fact and those facts are recorded in the fact tables.

The fact table lists events that happen in any company (or at least the events that important data like No of Unit Sold, Margin, and Sales Revenue, etc.) The Dimension tables precisely list out the factors (Customer, Requirement, Time, and Product) by which we want to analyze the data. Thus, it eliminates the hurdles involved in researching the entire organization data for business logics.