Skip navigation

November 2003 MDX Puzzle

If I told you that this year, sales for my new product line totaled $1 million, would you say that's good or bad? Without understanding how that number fits in with the rest of my business, you don't know. If you knew how other product lines were selling, what the total sales for my company were, or what this product's sales trend had been, you'd have a context for the $1 million sales figure.

A common way to put a number into context is to determine how much that number contributes to a greater whole. For example, when you view sales for a product family, you might also view what percent of total sales that product family is. For this month's puzzle, use the FoodMart 2000 Sales cube to write an MDX query that displays the cube's product families on the returned rows and Store Sales and Percent of Total Contribution (to Store Sales) on the columns.

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.