Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    HierarchyIndex function for IBM Planning Analytics (TM1)

      HierarchyIndex returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise.

      In this video, HierarchyIndex will be used to retrieve the dimension hierarchy index value and apply it in the rule to populate the Employee Salaries cube.​

      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