Defining the member sort order

By default, hierarchy members are shown in the order in which they are loaded into a dynamic cube.

You can select one or more attributes that define the sort order of the members within a level. For example, a Month level might have Month ID as a key attribute, Month Name as the caption attribute, and Month Number as an ordering attribute. Month Number is specified as the ordering attribute because Month Number sorts the months by calendar order whereas Month Name sorts the months alphabetically.

Procedure

  1. Right-click a level in the Project Explorer tree, and select Open Editor.
  2. Click Member Sort member sort icon.
  3. Select the required attributes from the Attribute column and click Add add icon to add them to the Sorting column.

    You can change the sort order by selecting an attribute and clicking Move Up move up icon and Move Down move down icon.

  4. To change the direction of sorting for an attribute, click the Direction column and select the required option.
  5. Click OK.