Skip to Content

BO4 - suppressing rows with empty/null column values automatically - possible?

Hi,

Have a report with 2 rows in it as can see from second row ,blank in second column.

Whilst can apply filters, is there a way to stop such columns appearing automatically?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 14, 2013 at 05:05 PM

    Create a variable Null_Filter

    = IF ISNULL([DIMENSION]) then 0 else 1

    Then create a block level filter on this variable to select only 1

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2013 at 05:33 PM

    If you want to filter this data out in the Universe, so that no end analytic/report will have that data available, you can add to the WHERE clause of the Measure:

         Value IS NOT NULL (or whatever nomenclature is requied for the flavor of SQL being used)

         Or

         Value <> '' (this is also represenation of NULL in some SQL)

    However, if you want this data available in the Universe and just want to suppress it in a Web Intelligence report, for instance, you can use the properties in the user interface tool to suppress that data.

    Add comment
    10|10000 characters needed characters exceeded