Setting the Dimension Sort Order in the Property Grid

You can set the processing order for a model dimension in the Dimension Sort Order property in the Property Grid.

A dimension sort order must be set for every dimension in the model, except Alias and UDA dimensions. The dimension sort order should be sequential, unique, and greater than or equal to 1.

Note:

The Alias dimension is ignored for Dimension Sort Order, as it does not exist as a dimension in Profitability and Cost Management and Essbase.

For Profitability and Cost Management, the dimensions must be sorted sequentially in the sequence specified in Table 16, Recommended Profitability and Cost Management Dimension Sort Order Settings; otherwise, validation of the model will fail:

  To set the Dimension Sort Order in the Property Grid:

  1. Select Navigate, Administer, Dimension Library.

  2. Edit a Profitability and Cost Management or Essbase application.

  3. Select a dimension.

  4. In the Property Grid, select one of the following categories, based on the type of application you are editing: Profitability, Essbase (BSO), or Essbase (ASO).

  5. For Profitability applications only, perform these tasks:

    1. Set the dimension sort order. For the recommended order, see Setting the Dimension Sort Order and Dimension Density.

    2. Validate the model. See Validating and Deploying.

Note:

For Essbase applications, if you change the dimension sort order after you deploy an application, you should redeploy and select “Full Deploy.”