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

MDX Puzzle #4

This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with a WHERE clause.  You can also do the same with MDX, but just like T-SQL there are a few ways to accomplish this.  In this puzzle you will see an example.  Here are the requirements:

Show: Internet Sales Amount

Columns:  Ship Date Calendar Year

Rows:  Product SubCategory

Filter:  Only return Product SubCategories that have sales greater than 1,000,000 and only return data between Calendar Year 2006 and 2008.

Hint:  Use the FILTER function to limit the rows by Sales Amount.

Remember, don't post your solution here.  Save them for my solution post.  I will post it along with the steps that was taken to solve this puzzle in a couple of days.  Here is a screen shot of what the results should look like:

image

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

Talk to you soon,

Patrick LeBlanc, SQL Server MVP, MCTS

Founder www.TSQLScripts.com and www.SQLLunch.com.

Visit www.BIDN.com, Bring Business Intelligence to your company.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.