TI Functions

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(DimensionNameHierarchyNameComponentSortTypeComponentSortSenseElementSortTypeElementSortSense);

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.