Skip to Content
0
Former Member
Apr 23, 2014 at 03:35 AM

Need help in suppressing a row in Webi - URGENT

371 Views

Gurus,

We are currently on BOBJ 4.0 We have a business requirement to suppress the row where both JDE Item Number = "#" and SAP Item Number = "#". We have a cross-tab webi report. This report is based on a BEx query and NOT on a Universe. Creating Universe for this webi report is not an option for us. Please see the attached screenshot.

I have tried creating filters to suppress this row, but no matter what I try this row keeps popping-up. I also tried creating variable that says show or hide and created a report filter based on this variable to "display" or "hide" but the filters messes-up the "JDE Qty" and "SAP Qty" metrics and makes them all to be #UNAVAILABLE. I also tried creating the below formula under "Hide when true" property of the table. But even this doesn't work.

=If([Item - Key] = "#" And [Material No - Key] = "#") Then "HIDE" Else "SHOW"

Since the filter/variable options didn't work, I tried creating a formula on JDE Qty and SAP Qty that makes all the measures to be Zero's. I then wanted to utlilize the webi table property hide row when sum of all measures = 0. Even that didn't work as we have done some formatting on JDE Qty and SAP Qty columns that make them appear as Zeros if they have blanks. After creating the formula, I see that I cannot have my custom setting for these 2 columns as the custom option itself is grayed-out. I have run out of options now.

Any suggestion to suppress this row is highly appreciated. This row appears only ONCE on the entire report, and the business is willing to make all measures values associated with this row to be zero to remove this row.

Points will be rewarded! Thanks gurus!

G.

Attachments

Row suppress.jpg (145.9 kB)