HierarchyIndex function for IBM Planning Analytics (TM1)

Where can the HierarchyIndex function be used?

Rules

Which TM1 Server version is the HierarchyIndex function available for?

Version 11 and 12

What is the syntax for HierarchyIndex?

HierarchyIndex(DimName, HierName)

• DimName =  Dimension name.
• HierName  = A valid hierarchy name.

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