Reordering Children Members

For all business dimensions in the model, you must reorder the list of members to display NoMember as the last Gen2 member; otherwise, validation of the model will fail.

You can also reorder members to suit your particular requirements as long as NoMember remains in the last position.

Note:

This step is not required for system dimensions, such as Alias, AllocationType, Measures, Periods, Scenarios or Years.

  To reorder children members:

  1. From EPM Workspace, select Navigate , then Administer, and then Dimension Library to display the Shared Library.

  2. Select the dimension to be reordered, as described below:

    • For Shared dimensions, under Shared Library, right-click the dimension that you want to reorder and then select Reorder Children.

    • For Local dimensions, under the Application column, right-click the dimension that you want to reorder and then select Reorder Children.

    The Reorder Children dialog box is displayed.

    Use this dialog box to reorder the sequence of children for a dimension in the Shared Library.

  3. Under Sort Order, double-click the cell for which the member is to be reordered, and enter the number of the new sort order location.

    The children for the dimension are shown with the new sort order.

    Note:

    Ensure the NoMember dimension is moved to the end of the list as the last Gen2 member; otherwise, the deployment will fail.

  4. Repeat step 3 to order all members.

  5. To preview the changes, click Preview.

  6. Click Save.