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

TurboIntegrator

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.

Use HierarchySortOrder to sort the dimension, Region not Sorted.