September 2002 MDX Puzzle

This month, I'm going to pitch a nice slow one right down the middle, and I expect everyone to hit it over the center field fence. Using the FoodMart 2000 Sales cube, write an MDX query that displays each product category and its average month-to-month store sales growth for 1997. Place the product categories on rows in descending order regardless of their product department groupings. In other words, the product category with the best average monthly growth rate in 1997 should be the first row displayed in the result. Format the average growth rate as a percentage with two decimal places of accuracy.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.