HierarchyN function for IBM Planning Analytics (TM1)
HierarchyN returns the name of the hierarchy at a specified position.
In this video, HierarchyN will be used to retrieve Employee Hierarchies dimension hierarchies name and apply it in the rule to populate in the Employee Salaries cube.
Where can the HierarchyN function be used?
Rules
Which TM1 Server version is the HierarchyN function available for?
Version 11 and 12
What is the syntax for HierarchyN?
HierarchyN(DimName, Index)
- DimName = Dimension name.
- Index = A value less than or equal to the number of hierarchies in the dimension.
Relevant Functions
- Hierarchy = Returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns an empty string
- HierarchyCount = Returns the number of hierarchies in the supplied dimension
- HierarchyIndex = Returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise
- HierarchyN = Returns the name of the hierarchy at a specified position