Sorts the elements and components of consolidations within a dimension.
DimensionSortOrder sorts the elements and components of consolidations within a dimension.
TurboIntegrator
DimensionSortOrder(DimName, CompSortType, CompSortSense, ElSortType , ElSortSense);
DimName = Dimension Name
CompSortType = sort type for components of consolidated elements
– ByInput: retain the original dimension element insert order
– ByName: sort by name
CompSortSense = the sense of order for CompSortType either ‘Ascending’ or ‘Descending’. This applies only when the CompSortType is ByName.
– Ascending: ascending alphabetical order
– Descending: descending alphabetical order
ElSortType = sort type for all elements
– ByInput: retain the original dimension element insert order
– ByName: sort by name
– ByLevel: Sorts dimension elements by level.
– ByHierarchy – Sorts dimension elements by hierarchy.
ElSortSense = the sense of order for ElSortType either ‘Ascending’ or ‘Descending’. This applies only when the ElSortType is ByName.
– Ascending: ascending alphabetical order
– Descending: descending alphabetical order
In the Sales Region dimension, sort the components by name in ascending order and elements by level in ascending order.
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