Measure Filtering in Universe Linked to Bex for zero suppression

[ozan_eroglu]

Hi All,

I've a BO explorer(polestar) report linked to a universe and connected to a Bex report.

Suppress Zeros option on BEX did not effect Universe.

I need to suppress zeros by filtering a measure in Universe. Can you please help me solving this?

The need is ,BO Explorer report shows averages according to Retail Location but the measure ( aggregation level is set to average in Universe) shows wrong number as it takes the records equal to zero.

Thanks in advance,

Ozan Eroglu

[Former Member]

Set Exception Aggregation to Calculated Key Figure in BEx to be "Average for all Detailed Values that are Not Zero, Null or Error".

[ozan_eroglu]

It doesn't work if you have retail location(plant) in your report, universe takes all the records including zeros.

Thanks anyway, any other idea??