Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 01, 2017 at 07:51 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 01, 2017 at 09:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2017 at 09:45 AM

    Hi Amit,

    Yes, I have checked with all combinations.

    Thanks,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded