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]