Hello every one, in this blog post, we will learn about Attribute Views in SAP HANA.
What is an Attribute View in SAP HANA
Attribute Views are information views in the SAP HANA.They are build in the HANA Modeling context.Attribute Views are built against master tables by joining them in SAP HANA.They can also used to project few columns from a master table.Attribute Views are reusable objects in SAP HANA.They can be compared to Database Views in ABAP or Dimensions in SAP BW (Business Warehouse). JOIN Engine in SAP HANA is used for Attribute View
You can also create hierarchies in attribute views to analyze the data in hierarchical manner.Two hierarchies can be created in attribute views 1. Level Hierarchies and 2. Parent Child Hierarchies
Types of Attribute View in SAP HANA
- Standard Attribute Views
- Derived Attribute Views
- Timed Attribute Views
Standard Attribute Views : These views are created among different column store tables using joins in SAP HANA.
Derived Attribute Views : These views are created using an existing Attribute Views.You cannot edit the derived attribute view.Derived attribute views are read-only.The only editable field in the derived attribute view is the description.It will behave as a reference to the base attribute view. Any changes to the base attribute view will be reflected in derived attribute view.
Timed Attribute Views : An attribute view which stores the time dependent data.They are created against calendar tables – M_FISCAL_CALENDAR (or) time tables – M_TIME_DIMENSION, M_TIME_DIMENSION_YEAR, M_TIME_DIMENSION_MONTH and M_TIME_DIMENSION_WEEK. All these tables are stored in _SYS_BI schema.
Where we can use these Attribute Views
Attribute Views are reusable objects and can be reused/shared in other views like Analytical Views and Calculation Views.
Attribute Views can also be exposed as XS OData service and these services are used in SAPUI5/SAP Fiori Applications.
Refer to this blog post on How to create an Attribute View in SAP HANA Studio.
Refer to this blog post on How to expose Attribute View as XS OData Service in SAP HANA.
Please stay tuned to us for more SAP HANA Modeling tutorials.Please feel free to comment and let us know your feedback. You feedback will keep us alive.