ORDER
1. ORDER (Syntax: Order(Set_Expression, Numeric_Expression [ , { ASC | DESC | BASC | BDESC } ] ) )
Description:
This function is used to arrange members of a specified set, optionally preserving or breaking the hierarchy.
Syntax:
Order(Set_Expression, Numeric_Expression [ , { ASC | DESC | BASC | BDESC } ] )
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Numeric_Expression | It is a valid numeric expression, typically an MDX expression of cell coordinates that returns a number. |
Example:
SELECT
[Measures].[Reseller Order Count] ON COLUMNS,
Order([Date].[Calendar].[Date].MEMBERS
,[Measures].[Reseller Order Count],DESC) ON ROWS FROM [AdventureWorksMF]2. ORDER (Syntax: Order(Set_Expression, String_Expression [ , { ASC | DESC | BASC | BDESC } ] ))
Description:
This function is used to arrange members of a specified set, optionally preserving or breaking the hierarchy.
Syntax:
Order(Set_Expression, String_Expression [ , { ASC | DESC | BASC | BDESC } ] )
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
String_Expression | It is a valid string expression, typically a valid MDX expression of cell coordinates that returns a number expressed as a string. |
Example:
SELECT
[Measures].[Reseller Order Count] ON COLUMNS,
Order([Product].[Product Categories].[Sub Category]
,[Product].[Product Categories].currentmember.name,BDESC) ON ROWS
from [AdventureWorksMF]