In sub type, there are three types of Attribute views − Standard, Time, and Derived. From the drop down list, choose View Type and sub type. Enter Attribute View name and description.
When you click on Attribute View, New Window will open. Right Click on Package → Go to New → Attribute View They are similar to Characteristics in BM and contain master data.Īttribute Views are used for performance optimization in large size Dimension tables, you can limit the number of attributes in an Attribute View which are further used for Reporting and analysis purpose.Īttribute Views are used to model master data to give some context.Ĭhoose the Package name under which you want to create an Attribute View. Characteristics of Attribute ViewĪttribute Views in HANA are used to join Dimension tables or other Attribute Views.Īttribute Views are used in Analytical and Calculation Views for analysis to pass master data. You can also copy a new Attribute View from already existing Attribute Views inside other Packages but that doesn’t let you change the View Attributes. They are used to join Dimension tables or other Attribute Views. These Objects can be added to Labels and Value axis by a right-click or by dragging the objects as shown in the following screenshot.Attribute Views in SAP HANA Modeling are created on the top of Dimension tables. SAP HANA also provides reporting feature for data analysis. Once you click Data Preview, it will show all the attributes that has been added to the Output pane under Available Objects. Now you can right-click the Attribute View and go for Data Preview.
Now click the Activate option and you will get a confirmation message in the job log. All columns will be added to the Output pane. Once the joining is complete, choose multiple attributes in the details pane, right-click and Add to Output. They can be joined using a Primary Key in the Details Pane as shown in the following screenshot. Once Tables or Attribute Views are added to Data Foundation, you can see all the columns on the right side pane. When you click Add Objects "+" sign in Data Foundation, you will get a search bar from where you can add Dimension tables and Attribute views to the Scenario Pane. You can add multiple Dimension Tables and Attribute Views in the Scenario Pane and join them using a Primary Key. You can add Objects to Data Foundation, by clicking the '+' sign written next to Data Foundation. Output pane where you can add attributes from the Detail pane to filter in the report. Scenario pane that has Data Foundation and Semantic Layer.ĭetails pane that shows the attribute of all tables added to Data Foundation and joining between them. When you enter the Attribute name, type, and sub-type and click Finish, it will open three work panes − Time sub-type Attribute View is a special type of Attribute view that adds a Time Dimension to Data Foundation. When you click the "Copy From" option, it shows all other Attribute views that you can use to create a copy. If you want to copy an existing Attribute view, you can use the "Copy From" option. Enter Attribute View name and description in this window and from the dropdown list, choose View Type and Sub-type.įollowing are the categories of Attribute View sub-type − When you click Attribute View, a new window will open. Right-click Package_Name → Go to New → Attribute View. Choose the Package name under which you want to create an Attribute View. In SAP HANA, all modeling objects are created inside the package and stored in HANA Repository. You can limit the number of attributes in an Attribute View, which are further used for reporting and analysis purpose.Īttribute Views are used to model the master data to give some context. They are similar to characteristics in BM and contain the master data.Īttribute Views are used for performance optimization in large size Dimension tables.
You can also copy a new Attribute View from the already existing Attribute Views inside other Packages, but that doesn't let you change the View Attributes.įollowing are the key characteristics of HANA Attribute view.Īttribute Views are used in Analytical and Calculation Views for analysis to pass the master data.
In SAP HANA, Attribute Views are used to model characteristics.