Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

MDX Puzzle #3

The next puzzle comes from a forum post.  Here are the requirements:

Columns:  Internet Order Quantity and Percentage Of Total (Calculation)

Rows: Product

Filter:  Return only the TOP 10 Products based on Internet Order Quantity.

Hint:  Use the WITH MEMBER statement to perform the calculation.  In addition, you will need to you the ROOT function or [ALL Products] to get the Total Quantity Ordered for the calculation.  Your result set should resemble the following:


Remember, don’t post you solutions here.  Save them for my solution post.  I will post it along with the steps that was taken to solve the puzzle in a couple of days.  

Don’t forget to check back in a couple days for the solution.

Talk to you soon,

Patrick LeBlanc, SQL Server MVP, MCTS

Founder and

Visit, Bring Business Intelligence to your company.


No comments.

Leave a Comment

Please register or log in to leave a comment.