Saturday, June 25, 2011

MDX: Define "Empty" cells so that they are not displayed

This post might not be important to many readers as this is probably a very simple technique to someone who knows MDX well, but I am hoping that at some point someone will find this helpful.

I had named calculations in my SSAS cube and the IIF formula defined a cell to contain "" (empty string) when the calculation could not be completed. The problem with this definition was that the "Filter Empty Rows" setting in Dashboard Designer did not work since these cells were not empty (although the looked empty), but instead they contained the empty string. The easiest fix is to instead of defining the cell to contain "", define it to contain null. Now the cell will be considered empty by Dashboard Designer and would be filtered.


No comments:

Post a Comment