Syntax

Order ( set, string_expr | numeric_value_expression [,BASC | BDESC] )

Parameters

set

The set to sort.

string_expr

String sorting criteria.

numeric_value_expression

Numeric sorting criteria (see MDX Grammar Rules).

BASC

If this keyword is used, the returned set is arranged in ascending order. Ascending order is the default even if no keyword is used.

BDESC

If this keyword is used, the returned set is arranged in descending order.

Example

The following MDX query displays budgeted Sales and Marketing in Qtr2, and the display of products is ordered based on ascending Actual Sales in Qtr1.

SELECT
 CrossJoin(
           {[Scenario].[Budget]}, 
           {[Measures].[Marketing], [Measures].[Sales]}
          )
ON COLUMNS,
 Order(
        [Product].Levels(0).Members,
        ([Year].[Qtr1], [Scenario].[Actual])
      ) 
ON ROWS
FROM Sample.Basic
WHERE ([Year].[Qtr2])

The above query returns the following grid: