#Unavailable error in webI

Hi,

I have a report wherein I have to restrict the zero values in the columns. The report is based on a SAP BW Bex query and the zero values come from a key figure. I cannot put the condition in the query filter since it doesnt allow me to pull the measure there.

If I try to put a report or a block level filter, the all the measures become #UNAVAILABLE. The report looks somewhat like the below:

Dim1| Dim2| Dim3| M1| M2| M3

A | B | C | #UNAV|#UNAV|#UNAV

M3 is the variable I need to put a filter on for supressing Zero. I have tried with the measure(key figure) and the underlying attribute(Formatted value). The result is the same. Please advise.

Thanks and regards,

V