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.

– Level Hierarchy

-Parent/Child Hierarchy

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

Leave a Reply