Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help with MDX Order by

0 views
Skip to first unread message

KCBTDev

unread,
Oct 14, 2008, 10:25:01 AM10/14/08
to
I want to order my mdx query by the most current dates volume. I am a newbie
to MDX but very profficient in SQL so bear with me.

This is the un-ordered query I have so far. This was an auto built query
from reporting services, but looks how i want it except for the ordering.

SELECT
NON EMPTY
{ [Measures].[AvgVolume],
[Measures].[Number of Trades],
[Measures].[AvgNumTrades],
[Measures].[Volume] } ON COLUMNS,
NON EMPTY
{([Date].[tradeDate].[tradeDate].ALLMEMBERS *
[User].[User].[User].ALLMEMBERS *
[Commodity].[Commodity].{Commodity].ALLMEMBERS ) }
DIMENSION
PROPERTIES MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM [UserStats]
CELL PROPERTIES
VALUE,
BACK_COLOR,
FORE_COLOR,
FORMATTED_VALUE,
FORMAT_STRING,
FONT_NAME,
FONT_SIZE,
FONT_FLAGS

How do I do it?

0 new messages