April MDX Puzzle Solution Revealed - 26 Apr 2001


According to the SQL Server Books Online (BOL) documentation, only the Enterprise Edition of SQL Server 2000 Analysis Services supports calculated cells. How can you solve the following problem without using calculated cells? Show Unit Sales for each drink product department for each quarter of 1997, and use cell properties to highlight in red those Unit Sales values that dropped from the previous quarter. You can also use a calculated member with cell properties to solve the same problem. In this solution, which Listing A shows, I created a new measure, New Unit Sales, which has the same values as the original Unit Sales measure. But I used an MDX formula inside the definition of the foreground-color cell property to force the solution to show decreasing Unit Sales values in red. Figure A shows the query result.

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.