InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 10:04:17 GMT20http://www.sqlservercentral.com/Forums/Topic1403459-17-1.aspx[quote][b]sathiyan00 (1/7/2013)[/b][hr]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][/quote]Take a look at the Stairway to MDX here on SSC: [url]http://www.sqlservercentral.com/stairway/72404/[/url] for an intro to MDX.Also look at getting a MDX book. An older book, but a pretty decent one is: [url]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[/url]HTH,RobMon, 07 Jan 2013 06:38:41 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1403459-17-1.aspxHi 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 Mon, 07 Jan 2013 01:32:54 GMTsathiyan00