February 2002 MDX Puzzle

A good analysis solution provides up-to-date, relevant information. For some businesses, the most important information predicts end-of-quarter sales figures. Using the FoodMart 2000 Sales cube, create a calculated measure that returns a prediction of unit sales for the end of the current quarter. Then, use this calculated measure in an MDX query to predict the unit sales for each month in fourth quarter 1997.

To set up your prediction, figure out how far along you are in the current quarter—for example, you might be in the first month of fourth quarter 1997. Then, look back at the first three quarters of 1997 and determine what percentage of the total quarterly sales were complete after the first month of each quarter. Average the percentages from the previous three quarters, and use that number to predict what your sales will be when the fourth quarter is complete.

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.