SAP HANA Modeling

[Former Member]

SAP HANA Modeling using SAP HANA Studio

SAP HANA modeler is a graphical data modeling tool which allows you to design analytical models and later analytical privileges, that governs the access to those models.

Information views are created to model various slices of the data stored in an SAP HANA database. Information views use various combinations of content data (that is, non-metadata) to model a business use case.

Content data can be classified as follows:

• Attribute - Represents the descriptive data like customer ID, city, country, and so on.
• Measure - Represents the quantifiable data such as revenue, quantity sold, counters, and so on.

Information views are often used for analytical use cases such as operational data mart scenarios or multidimensional reporting on revenue, profitability, and so on.

There are three types of information views:

• Attribute view
• Analytic view
• Calculation view

All three types of information views are non-materialized views. This creates agility through the rapid deployment of changes.

Here is the "How to" video which shows creating all three types of views using SAP HANA Studio.

Thanks,

Rohit Patwardhan

United Software Associates

http://www.usain.com/sap_hana.aspx