Sorting Members

You can sort members to facilitate viewing them within member selection. By default, the members are displayed in the sort order of the database connection.

You can sort selectable members in a preferred order, and you can sort the members that are selected to match the row or column order of data in your report. The order in which selected items are displayed in member selection is the order in which they are evaluated and displayed on the report.

You sort the members by property and display them in ascending or descending order. By default, the system sorts the list numerically, then alphabetically.

You can enable the system to sort the list whenever the view changes, or you can sort the list manually.

  To sort members manually:

  1. Open a report.

  2. Double-click a dimension cell for which you want to sort members.

  3. In the Selected Members list, click View, then select Sort.

  4. In the Sort (dimension) Items dialog box, select the property for the primary sort, then click Right Arrow icon. Optionally repeat this step to select a second and third sort method.

  5. Click OK twice.