Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to hide a row when the values became 0 in pivot table when choosing a value from the DBPrompt

1034244Oct 15 2013 — edited Oct 19 2013

Hi friends,

I am new to OBIEE.

I am using a pivot table and I need to hide the entire row when it becomes 0. Based on the prompt it will return the values.

I tried using the Filter with the Prompt column and the fact columns (is not = 0). When the columns has the value, it returns the Output. When the fact column is 0 then entire table is not displaying.

And I found whats the error.. While using the filter I used AND condition.. If all the condition becomes true then only it will return the value.

Is there is any other solution to hide the row when it has the value 0.

Regards,

Sathya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2013
Added on Oct 15 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
6 comments
1,438 views