Persistent NONEMPTY() in ProCalrity 6.3 Query RRS feed

  • Question

  • The NONEMPTY() appears to be used ‘automatically’ in the ProCalrity MDX query, but there are many situations where I don’t want it used. And I can’t get rid of it! The NONEMPTY() is used when there is more than on hierarchy nested on the ROW or COLUMN axis (which is where the NONEMPTY() is also applied).

    My client needs to see the 'empty' data intersections for future periods where actuals are not populated.

    How can I turn the NONEMPTY() off? Is there a workaround?


    Paul Goldy
    Friday, April 30, 2010 4:08 PM