Microsoft SQL Server 2005 Analysis Services

Functions for Ordering Data

When you’re analyzing data, you quite often need to see it in some particular order asso-

ciated with the data value. For example, perhaps you want to see the stores that are

performing well first and lower-performing stores last. The

Order function sorts the tuples

in the set according to the value of the expression you provide as a parameter. For

example, if we are ordering stores according to the values of the

Stores Sales measure,

we can write the following MDX statement:

SELECT Order( [Store].[Stores].[Store].members, [Measures].[Store Sales], BDESC)

➥ ON COLUMNS FROM [Warehouse and Sales]

That statement returns the set ...