• subscribe
May 20, 2003 12:00 AM

June 2003 MDX Puzzle

SQL Server Pro
InstantDoc ID #38721

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.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here