Defining Order By Clauses
Order By clauses specify the order the selected key figure or dimension property is returned. Use the Order tab in the Query Clause section of the Fields page to define an Order By clause.
To add a key figure or dimension property to an Order By clause:
Drag a key figure or dimension property from Characteristics and Key Figures to Order.
Select a key figure or dimension property under Characteristics and Key Figures and click 
.
Double-click a key figure or dimension property.
Table 38. Order By Clause Options
| Option | Description |
|---|
Key Figures/ Dimension Properties | Selected key figure or dimension property. |
Characteristics | Caracteristic in the hierarchy for the key figure or dimension property. Use the drop down list to select a characteristic. |
Sort Values | ASC—Sort in ascending order and preserve the hierarchy. BASC—Sort in ascending order and break the hierarchy. DESC—Sort in descending order and preserve the hierarchy. BDESC—Sort in descending order and break the hierarchy.
|
Sort All Key Figures | Sorts all the key figures or dimension properties for the selected SAP BW object. |
Up/Down Arrows | Changes the sequence of key figures or dimension properties in the Order by clause. |