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:
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.