September 2003 MDX Puzzle

This market-basket analysis problem isn't for the faint of heart. Use the FoodMart 2000 Sales cube to determine which 10 non-beer products customers purchased most frequently in the same transaction with beer products. For this problem, I define a transaction as a unique combination of a customer, a store, and a month. Be careful with this one: If you write your query inefficiently, you might have Analysis Services looking for the answer overnight.

Format the results of your query so that the top 10 products are on the rows and both store sales and the number of transactions are on the columns. Here's a hint: Try to use the concepts in the main article to make your query more efficient. The answer I came up with ran for 3 minutes on my 1GHz laptop.

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.