MDX FLOW

• sathiyan00

  SSCommitted

  Points: 1879

  More actions

  January 7, 2013 at 1:32 am

  #145880

  Hi friends,

  I'm new to mdx . anyone please explain the flow of this or any simple mdx expression.so that i can get some idea about mdx expressions.

  EXPRESSION:

  WITH SET [top subcategories for internet savvy states] AS

  GENERATE( FILTER({[Order Date].[MyHierarchy].[Calendar Year].[2003].Children},

  ([measures].[Order Quantity])>100), CROSSJOIN( [Order Date].[MyHierarchy].currentmember,

  TOPCOUNT([Dim Product].[English Product Name].members, 2, [measures].[Order Quantity] ) ) )

  SELECT [top subcategories for internet savvy states] ON ROWS, {[measures].[Order Quantity]} ON COLUMNS FROM [dec17_cube]

  thanks

  Rahul

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  January 7, 2013 at 6:38 am

  #1574283

  sathiyan00 (1/7/2013)

  ---

  Hi friends,

  I'm new to mdx . anyone please explain the flow of this or any simple mdx expression.so that i can get some idea about mdx expressions.

  EXPRESSION:

  WITH SET [top subcategories for internet savvy states] AS

  GENERATE( FILTER({[Order Date].[MyHierarchy].[Calendar Year].[2003].Children},

  ([measures].[Order Quantity])>100), CROSSJOIN( [Order Date].[MyHierarchy].currentmember,

  TOPCOUNT([Dim Product].[English Product Name].members, 2, [measures].[Order Quantity] ) ) )

  SELECT [top subcategories for internet savvy states] ON ROWS, {[measures].[Order Quantity]} ON COLUMNS FROM [dec17_cube]

  Take a look at the Stairway to MDX here on SSC: http://www.sqlservercentral.com/stairway/72404/ for an intro to MDX.

  Also look at getting a MDX book. An older book, but a pretty decent one is: http://www.amazon.com/Fast-Track-MDX-Mark-Whitehorn/dp/1846281741/ref=sr_1_1?ie=UTF8&qid=1357565829&sr=8-1&keywords=fast+track+to+mdx

  HTH,

  Rob