You can reorder children in the Dimension Library.
To reorder children:-
In the Shared Library or Application pane, drag a member up or down the tree to change the order, or right-click the dimension where you want to reorder the children, and then select Reorder Children.
Note:
For Profitability and Cost Management models, you must reorder the list of members for all business dimensions in the model to display NoMember as the last member; otherwise, validation of the model fails. This step is not required for systems dimensions, such as Alias, AllocationType, Measures, Periods, Scenarios, or Years.
If you want to reorder children in a local dimension, you can modify the order in the Application pane of the Dimension Library. However, if the dimension is shared, you must modify the order in the Shared Library pane versus in the Application pane.
-
Perform an action to change the order:
-
Double-click the sort order, and enter a new number.
-
Select the row, then press F2 and enter a new number.
-
Select the row and use the arrows to change the order.
-