Sets the order in which elements in a dimension are organized and displayed.
HierarchySortOrder sets the order in which elements in a dimension are organized and displayed.
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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.Book