NON EMPTY Doesn't filter Empty tuples RRS feed

  • Question

  • Hi,
    I've got an SSAS 2005 cube with a few dimensions that don't have measure values for a lot of their values, so filtering out EMPTY is very useful.  When filter empty columns and rows is selected, however, these empty tuples are still displayed.

    I'm running PAS 6.3, but I don't think many patches or the SP's have been applied.  I'm planning to try this, but I'm also wondering if it's a dimension design issue.  I've run into this in the past, but not recently.

    Is this a dimension design, PAS version, or user query issue?


    Friday, March 27, 2009 2:55 PM

All replies

  • It's probably not a PAS version issue.  I would actually recommend starting with Management Studio to see if you can isolate the problem.  That is, take the same queries from ProClarity and run them in Management Studio and notice the results.  Once you get what you want out of there, move back to ProClarity and see if it's just a problem in the ProClarity application, at which point an update would be appropriate.
    Microsoft ProClarity | This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, March 30, 2009 11:29 PM