Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    HierarchyCount function for IBM Planning Analytics (TM1)

      HierarchyCount returns the number of hierarchies in the supplied dimension.

      In this video, HierarchyCount will be used to retrieve the Employee Hierarchies dimension number of the hierarchy and apply it in the rule to populate the Employee Salaries cube.

      Where can the HierarchyCount function be used?

      Rules

        Which TM1 Server version is the HierarchyCount function available for?

        Version 11 and 12

          What is the syntax for HierarchyCount?

          HierarchyCount(DimName)

          • DimName =  Dimension 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