Creating hierarchies
Hierarchies are created to maintain data in a structured format, such as maintaining customer or employee data based on their roles and splitting data based on geographies. Hierarchical data is very useful for organizational purposes during decision making.
How to do it…
Two types of hierarchies can be created in SAP HANA: the level hierarchy and parent-child hierarchy in the attribute view or analytic view. The hierarchies are initially created in the attribute view and later can be combined in the analytic view or calculation view for consumption in report as per business requirements. Let us create both types of hierarchies in attribute views. When these attribute views are used in analytic views, the hierarchies created in attribute views will be inherited to drill up, drill down, or drill across in the reports for multidimensional analysis.
Level hierarchy
Follow the given steps to create a level hierarchy:
In the attribute view, go to the Semantics section. On the...
