Hiding the columns with no data in WEBI

Hi All,

We are in the process of developing WEBI reports using Bex queries. We have a requirement where the columns with no data should be hidden and once the same column gets updated with the data is to be displayed in the output of the report. We achieved the same requirement in the BEx query by using the Query Property, Supress Zeros --> Active. The same is working fine in BI.

But when we are executing the WEBI report based on the same query, the above setting in the query designer is getting ignored and displaying the columns with null values. Can you please guide me how to supress the columns with no values (Zeros) in WEBI environment.

Thanks & Regards,

Satish.