Home » Technology » A Comprehensive Overview of SAP HANA Modelling
SAP HANA Modelling

A Comprehensive Overview of SAP HANA Modelling

What is SAP HANA Modelling?

An activity through which we make an information view, SAP HANA Modelling is quite close in likeness to cube, dimension, or BW information provider. A multi-dimensional data model is developed using the information view.

SAP HANA Modelling is an activity by which we create information view. Information View is similar to dimension, cube or information provider of BW. This information view is used for creating the multi-dimensional data model.

Overview of Modelling in SAP HANA

We are able to cut data in a table of data, or refine it to a user’s needs through modelling. This is done by making an information view which is structured on the scenario of business. These views of information can be applied to do reporting and for the purpose of decision making.

Many different combinations of the data content is used to make an information view for a business scenario model.

There are two types of Content Data in the information view. These are

  1. Attribute: It is descriptive and non-measurable data. For example, vendor name, vendor id, city name are all attributes.
  2. Measure: All data can be calculated and quantified at Stechies. For example, the amount sold, revenue, counters, etc. You can’t create measure in the attribute view.

Types of Attribute

There are 3 attribute types that are supported by SAP HANA:

  1. Simple Attribute: This is an attribute that is got from data foundation.
  2. Calculated Attribute: This is an attribute that is got from one or more constants and attributes that are already pre-existing. For example, the arithmetic calculation or deriving the complete name of a vendor from the first name and the last name.
  3. Local Attribute: This is an attribute that is used in the analytical view and the calculation view (modelling views) to customise the behaviour of the attributes. Thus this is local to modelling view. It can’t be accessed from anywhere outside the modelling view.

Types of Measure

There are four types of measures that are supported by SAP HANA. They are:

  1. Simple Measure: The Simple Measure is a set of methods that is derived from the data foundation.
  2. Calculated Measure: The Calculated Measure is a set of methods that is got from one or more of the constants or measures and functions that are already pre-existing. For example, arithmetic calculation is a calculated measure.
  3. Restricted Measure: The Restricted Measure is a set of methods that is used to filter values that are based on user defined rules for other attribute values.
  4. Counter: Counter is a special type in the columns that is used to show a unique number for the attribute columns (calculation view or analytical view). It is used to keep a count of one or more of the columns used for attributes.

Types of Information Views

There are three types of Information Views as well. They are listed below:

  1. Attribute View: This view is used for the context of master data.
  2. Analytic View: This view is used for making fact tables that are not dissimilar from that of Cube of BW.
  3. Calculation View: This view is used to create a complex view which is similar to multiple Provide in BW.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*