SAP HANA

SAP HANA Information Models

Saurav Mitra

In this article we will see how to design Information Models in SAP HANA Database. So first of all we will create a Package and then we will model Attribute, Analytic and Calculation Views.

Also we will create an Analytic Privilege on an Analytic View and Grant it to Users and Roles. So let's get started.

Log on to SAP HANA Studio. Next change the Perspective to Modeler.

SAP HANA Studio-Modeler

Create Package

Package are used to group together the related information objects for structuring purpose. From the Quick Launch select the Package link and click the button Create.... Alternatively, right-click the Default Content folder in the left-side Navigator and select New Package.

Create Package

Next Enter the name of the Package. Select the Original Language and Person Responsible from the dropdown list. Press OK.

New Package

Next expand the Content folder and check that the Package was created successfully. Here in the example this is pkg-material-sales.

Information Package

Create Attribute View

Attribute Views are used to model Master data tables. Now we will create a dimension table or Attribute View in the same Package that we have created. From the Quick Launch select the Attribute View link and click the button Create.... Alternatively, right-click the Package and select New Attribute View.

Create Attribute View

Enter the name of the Attribute View based on the Master data table to be selected for modeling. Enter a description and select the Package name from the dropdown list. Make the Attribute View Type as Standard. Click Next.

New Attribute View

Select the Required tables to define the Attribute View. We can search the available table by name; Else from the context menu under catalog->Schema select the table and click the Add button. Click Finish.

Attribute View- Select Tables

Next we need to define the properties of the Attribute View. In the Navigator we can see the Attribute View, but that is not yet been defined, validated, saved and activated.

Attribute Views

Next we need to define the Key Attributes, Attributes, Calculated Attributes, Filter, Join etc. in the Data Foundation tab of the Attribute View Editor workspace.

Validate, Save and then Activate. Next select the data preview to verify that the Attribute view is modeled correctly.

To be continued...