August 2002 MDX Puzzle

A common type of retail sales analysis is consolidation analysis. One example of consolidation analysis is Customer consolidation analysis: If fewer customers are buying more products, your customers are consolidating. If more customers are buying fewer products, your customers aren't consolidating. Using the FoodMart 2000 Sales cube, write an MDX query to determine whether the top 10 FoodMart customers are consolidating throughout the four quarters of 1997.

To solve this puzzle, you need to create an MDX query that includes the four quarters of 1997 on the columns of the query's result. Then, create two rows. The first row should display the total number of store sales attributed to the top 10 customers altogether. The second row should display the percentage of total store sales attributed to the top 10 customers altogether.

Hide comments

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.
Publish