TM1 Function for TI – HierarchySortOrder
Available In
TurboIntegrator
Definition
HierarchySortOrder sets the order in which elements in a dimension are organized and displayed.
Syntax
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:
Video Demo
Use HierarchySortOrder to sort the Region not Sorted dimension.