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 the data based on geographies. Hierarchical data is very useful for organizational purposes during decision making.
Two types of hierarchies can be created in SAP HANA:
The level hierarchy
Parent-child hierarchy
The hierarchies are initially created in the attribute view and later can be combined in the analytic view or calculation view for consumption in a report as per business requirements. Let's create both types of hierarchies in attribute views.
Creating a level hierarchy
Each level represents a position in the hierarchy. For example, a time dimension might have a hierarchy that represents data at the month, quarter, and year levels. Each level above the base level contains aggregate values for the levels below it.
The following are the steps to create level hierarchy:
Create a new attribute view (for your own practice, I would...
