<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

HierarchySortOrder function for IBM Planning Analytics (TM1)

    HierarchySortOrder sets the order in which elements in a dimension are organized and displayed.

    In the video, HierarchySortOrder will be used to sort the dimension, Region, not Sorted.

    Where can the HierarchySortOrder function be used?

    TurboIntegrator

      Which TM1 Server version is the HierarchySortOrder function available for?

      Version 11 and 12

        What is the syntax for HierarchySortOrder?

        HierarchySortOrder(DimensionName, HierarchyName, ComponentSortType, ComponentSortSense, ElementSortType, ElementSortSense)

        • ​​​DimensionName = Name of the dimension to be sorted​
        • HierarchyName = Name of the Hierarchy to be sorted​
        • ComponentSortType = Determines how components of consolidations will be sorted inside the dimension. There are two ways of sorting.
        • ComponentSortSense = Required parameter but applied only when ‘ComponentSortType is ‘ByName’. Determines the order in which components of consolidations will be organized.
        • ElementSortType = Determines how elements will be sorted inside the dimension. There are four ways of sorting.
        • ElementSortSense = Required parameter but applied only when ‘ElementSortType’ is ‘ByName’ or ‘ByLevel’. Determines the order in which consolidations will be organized.

        Relevant Functions