Skip to Content
0

WEBI - show columns for which all measures = 0, with empty measure values does not work

May 01, 2017 at 09:49 AM

449

avatar image

Hi Friends,

We are on SAP BI BO 4.2 SP2 and currently making few webi reports. one of the issue we are facing is to hide the column which has all zero values or empty values.

Cross tab properties has the provision to show/hide the columns where all the measure are zero or empty but when I untick them to hide those columns, it does not work.

Screenshot is attached to show the scenario.

issue-webi.png

Thanks,

Gaurav

issue-webi.png (51.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
May 01, 2017 at 07:51 PM
0

have you tried after unchecking "Show rows/columns with empty dimension values".This is checked in your screenshot.

Share
10 |10000 characters needed characters left characters exceeded
Sasi Vemulapalli May 01, 2017 at 09:09 PM
0

Hi,

You can check these topics,hiding zero value data rows in webi report.

https://archive.sap.com/discussions/thread/1879196

https://michaelwelter.wordpress.com/2010/12/16/suppress-rows-with-zero-value/

Thanks,

Sasi

Share
10 |10000 characters needed characters left characters exceeded
TCS Team May 03, 2017 at 09:45 AM
0

Hi Amit,

Yes, I have checked with all combinations.

Thanks,

Gaurav

Share
10 |10000 characters needed characters left characters exceeded