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

[former_member272336]

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

[Former Member · Accepted solution]

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

[dennis_scoville4]

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.

[former_member272336]

Thanks for replies.