Sort dialog box
The Sort dialog box is used to sort a table to control the order of members within a dimension. You can sort on one or more columns. For example, you can sort by currency and by ID in ascending order to have the members automatically sorted alphabetically when the dimension is created.
The Sort process is modified when creating an hierarchical or schedule dimension. For hierarchical dimensions, the parents always come before its descendants. Then the sort order is applied. For the schedule dimension, members contributing to a downfoot always come before the downfoot.
The Sort option is used when first creating a dimension or with the Replace Dimension option; it does not change the order of an existing dimension during the Update Dimension process.
This capability is available when importing from database tables or views.
These are the dialog box options:
| Option | Description |
|---|---|
| Delete Level | Deletes the selected row. |
| Move Level Up | Moves the selected row up one level. |
| Move Level Down | Moves the selected row down one level |
| Sort by Column | Specifies the column on which to sort. You can specify multiple columns. Press to add more lines to the table. |
| Order | Sort order, ascending or descending. |