Order MDX query alphabetically - Member_Caption

This code example demonstrates Sql programming techniques and best practices.

            SELECT
{ [Measures].[Sum of Orders], [Measures].[Sum of Cost], [Measures].[Sum of Demand Revenue], [Measures].[Average of CPM], [Measures].[Avg of AOV], [Measures].[Sum of Budget] }
ON COLUMNS,

{ 
Order(
[activity].[Funnel Position].[Funnel Position].ALLMEMBERS
, [activity].[Funnel Position].Member_caption, desc
)
} * { [activity].[Channel].[Channel].ALLMEMBERS }
ON ROWS

FROM [Model]

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, FONT_FLAGS, FORE_COLOR, BACK_COLOR
        

Language: Sql
Original Source: BlogEngine.NET Migration
Code Lines: 51

Order MDX query alphabetically - Member_Caption

SELECT{ [Measures].[Sum of Orders], [Measures].[Sum of Cost], [Measures].[Sum o