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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to hide rows if all values are Zero (0) horizontally?

872653Nov 19 2011 — edited Nov 23 2011
Hi,



I have got a requirement to hide rows from the results if all values are equal to zero horizontally.


Example:


Region   M1    M2   M3

East     0      0    3

West    10     20    0

South   -5      0    5

North    0      0    0
In the above example only North Region row should be hidden from the results becasue all the measures values are zero.

Can someone please let me know the logic to achieve this?





Thank in advance.
This post has been answered by 723137 on Nov 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2011
Added on Nov 19 2011
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
4 comments
151 views