{"id":47689,"date":"2019-01-28T13:30:57","date_gmt":"2019-01-28T08:00:57","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=47689"},"modified":"2021-12-05T21:47:10","modified_gmt":"2021-12-05T16:17:10","slug":"sap-hana-modeling","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sap-hana-modeling\/","title":{"rendered":"SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects"},"content":{"rendered":"

This SAP HANA tutorial<\/strong> is dedicated to learning a very crucial aspect and functionality known as SAP HANA Modeling. A lot of SAP HANA\u2019s applications are based on its capability of creating data models and business logic through modeling practices. In the sections to follow, we are going to learn about attributes and measures of,\u00a0privileges required and\u00a0types of modeling objects in SAP HANA.<\/p>\n

What is SAP HANA Modeling?<\/h3>\n

Modeling in SAP HANA showcases data from the databases 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 such as 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.<\/p>\n

That is, raw data taken from data sources is converted into business utilizable data by applying business logic on it. SAP HANA\u00a0modeling is performed via the SAP HANA Studio<\/strong> Modeler (which is an interface) and is applied directly on the database layer (in-memory).<\/p>\n

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\u2019s 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.<\/p>\n

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.<\/p>\n

We can create a SAP HANA data model in the modeler\u00a0perspective of the SAP HANA Studio. You can access the database and tables as the schemas present under the Catalog tab<\/strong>. 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<\/strong> present in the system view section of the Studio.<\/p>\n

These SAP HANA information model<\/strong> 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 (containing primary keys).<\/p>\n

What are the attributes and measures?<\/h3>\n

The business models created in SAP HANA Modeler use data in a particular form. We can use content data within information views, as attributes and measures.<\/p>\n

Attributes<\/strong>, as the name suggests, is the descriptive or contextual data which provides information on the data being used in tables. Thus, the attributes are the characteristics of data such as Country, Store, Sales ID, Customer Name, etc. Attributes are the non-measurable data types and cannot be used in calculations.<\/p>\n

Whereas, measures<\/strong> are the data entries, which are calculable as well as measurable.<\/p>\n

The views that use measures can be utilized for analytical purposes. The data as a measure can be used as Sales Amount, Product Quantity, Profit percentage, etc. There are different types of attributes as discussed below.<\/p>\n

a. Types of Attributes<\/h4>\n

There are three types of attributes in SAP HANA Modeling.<\/p>\n