Use the Sort Selection dialog box to sort dimension values in a selection. The methods of sorting you can use depend on the dimension's properties.
The available components vary according to the current dimension and the options you select.
Based on box -- Lists the sorting methods, as follows:
Alphabet -- Sorts values in alphabetical order, either A to Z or Z to A.
Database -- Sorts values in the order the dimension values are stored in the database, either in standard or reverse order.
Data Value -- Sorts values based on the corresponding data values in a measure, either low to high or high to low. The following additional boxes appear when you choose this method:
Using box -- Specifies the measure from which to use data values. To select a different measure that uses the current dimension, click on the Ellipsis button.
For box -- Lists the other dimensions for the measure chosen in the Using box and identifies a single dimension value for each one. To change a dimension value, choose the Ellipsis button.
Dragdrop -- Enables you to sort values manually. A dimension list box displays the values in the current selection. You can click and drag a value to a different position in the list.
Hierarchy -- Sorts values based on their order in the hierarchy, either top to bottom or bottom to top. Available only when the selected dimension has a hierarchy. When you choose this method, the In Hierarchy box appears, which allows you to select a hierarchy.
Level -- Sorts values based on their level, either from top to bottom or from bottom to top. Available only when the selected dimension has a hierarchy. Note that the sort affects the order of levels, but does not alter the order of values within a level. When you choose this method, the In Hierarchy box appears, which allows you to select a hierarchy.
Time -- Sorts values from earliest to latest or latest to earliest. Available only if you are working with the Time dimension. When you choose this method, the In Hierarchy box appears, which allows you to select a hierarchy.
In hierarchy box -- When you choose Data Value, Hierarchy, Level, or Time in the Based On box, the In Hierarchy box lists the hierarchies that are defined for the selected dimension. Select the hierarchy that you want to use.
In order box -- Lists the sort-order options for the Alphabet, Database, Data Value, Hierarchy, Level, and Time methods.
Script box -- Displays the criteria that will be added to the selection script if you choose OK.
Preview button -- Displays the Preview dialog box, which allows you to examine the change you are considering and lists the dimension values that will be selected if you adopt the change.
Sort automatically check box -- Specifies whether the dimension is sorted automatically each time the selection changes.
Replacing or refining a selection
Copyright © 1984, 2005, Oracle. All rights reserved.