June 2003 MDX Puzzle

For a twist, try June's puzzle. It'll get you to think upside down!

Russ Whitney

May 19, 2003

1 Min Read
ITPro Today logo

Using the FoodMart 2000 Sales cube, write an MDX query that displays only the product categories on rows that contain products that are in the top five based on store sales. On the columns, display only Store Sales. Here's a hint: This puzzle will get you to think upside down! You have to start at the bottom of a dimension and work up.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like