1. Administrator's Guide
  2. Working with Standard Profitability
  3. Working with Standard Profitability and Cost Management Dimensions and Members
  4. Dimension Sort Order and Density Settings
  5. Dimension Sort Order Recommendations

Dimension Sort Order Recommendations

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 Oracle Hyperion Profitability and Cost Management and Oracle 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.