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.
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.
Next Enter the name of the Package. Select the Original Language and Person Responsible from the dropdown list. Press OK.
Next expand the Content folder and check that the Package was created successfully. Here in the example this is pkg-material-sales.
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.
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.
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.
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.
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...