Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX FLOW Expand / Collapse
Author
Message
Posted Monday, January 7, 2013 1:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 15, 2014 2:05 PM
Points: 73, Visits: 475
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

Post #1403459
Posted Monday, January 7, 2013 6:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:47 PM
Points: 1,170, Visits: 1,211
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
Post #1403574
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse