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:
-
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.
-
In the Profitability Applications Console, select Actions, and then Update Dimensions to load the file with the dimension sort order defined.