HierarchyN function for IBM Planning Analytics (TM1)

Where can the HierarchyN function be used?

Which TM1 Server version is the HierarchyN function available for?

What is the syntax for HierarchyN?

• 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