Real Time Analytics with SAP HANA

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 ...