SAP HANA Hierarchies
In SAP HANA we have 2 types of Hierarchy
1. Level Hierarchy
It’s rigid in nature, where the root and the child nodes can be accessed only in the defined order (ex: organizational sturctures)
To define a level hierarchy we need one attribute per hierarchy level.
2. Parent/Child Hierarchy
The hierarchy can be explored based on a selected parent, and there are cases where the child can be a parent.
They are only accessible via MDX.
1. On the Hierarchies tab page, choose Create.
2. Enter a name and description for the hierarchy.
3. Select a Hierarchy Type.
4. Choose OK.
5. Add the required attributes.