1. Administrator's Guide
  2. Working with Detailed Profitability
  3. Working with Detailed Profitability and Cost Management Dimensions and Metadata
  4. Setting the Dimension Sort Order

Setting the Dimension Sort Order

The processing order for every dimension in the model must be set at the dimension level using a Dimension Sort Order property in the dimension load files.

The dimension sort order restrictions must be met; otherwise, validation of the model fails. For a complete list of restrictions, see Dimension Sort Order Recommendations.

To construct a load file that includes the dimension sort order:

  1. In an external program or ETL process, construct a load file with columns similar to these. Make sure to include a column for the Dimension Sort Order.

    Enter a sort order for the root member of the dimension. In this example, Accounts has sort order of 9.


    Sample table used as a sort order load file

  2. In the Profitability Applications Console, select Actions, and then Update Dimensions to load the file with the dimension sort order defined.