MDX Puzzle - 01 Sep 1999

In the FoodMart Sales cube, you want to list the Unit Sales values for California in all quarters for 1997 and 1998. That query is simple enough, but if one of the cell values in the result is empty, how do you get the result to display n/a? We'll answer that question next month. Until then, if you have ideas or questions for future columns, please send us email at [email protected]

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.