Oracle recommends that you set the dimension sort using the following recommendations:
A dimension sort order must be set for every dimension in the model, except Alias and UDA.
Note: | The Alias and UDA dimensions are ignored for Dimension Sort Order, as they do not exist as dimensions in Profitability and Cost Management and Essbase. |
The dimension sort order must be sequential, unique, and greater than or equal to 1.
Measures dimension is set to 1, by default.
AllocationType dimension is set to 2, by default.
Business and POV dimensions must be set to 3 or higher.
Attribute dimensions must always be sorted as the last dimensions. For example, if you have four attribute dimensions in a sequence of 12 dimensions, the attribute dimensions must be set as 9, 10, 11, and 12.