The processing order for every dimension in the model must be set at the dimension-level using the Dimension Sort Order property. The Dimension Sort Order restrictions must be met; otherwise, validation of the model will fail. For a complete list of restrictions, see Dimension Sort Order Recommendations.
There are two ways to set the dimension sort order in Performance Management Architect:
Using the Dimension Performance Settings dialog box to set the sort order for all dimensions at one time
Using the Property Grid in the Dimension Library to set individual dimension sort order for one dimension at a time
To set the Dimension Sort Order using the Dimension Performance Settings dialog box:
From EPM Workspace, select Navigate, then Administer, and then Dimension Library to display the Shared Library.
Right-click the name of the application, and select Dimension Performance Settings.
Select a dimension, and use the Up
and Down 
arrows to move each dimension into the correct sort order, as described in Dimension Sort Order Recommendations. The number of the original position for the dimension is displayed under Sort Order.Optional: Under Density for the selected dimension, double-click the cell to display the options, and then select the appropriate density for the dimension. See Optimizing Dimension Settings for Essbase.
To set Dimension Sort Order for individual dimensions:
From EPM Workspace, select Navigate, then Administer, and then Dimension Library.
In the Profitability and Cost Management application, select the dimension for which you want to set the Dimension Sort Order.
In the Property Grid, select the Dimension Sort Order property, and under Value, enter the required number for the sort order. See Dimension Sort Order Recommendations.
.