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 filter view calculations in answers in obiee 11g?

995724Aug 13 2013 — edited Aug 14 2013


Hi,

I have a requirement to hide the "CASE WHEN" statements which are there in the filter view while viewing the report in Dashboard. User dont want to see the calculation part in filter view instead they just want to see the selected dashboard prompt value. For e.g

case when (column name1('column value1' IN '@{Presentation_var}' ) > 0 AND "Table name"."column name2"='column value2') or (column name1('column value1' IN '@{Presentation_var}' ) > 0 AND "Table name"."column name2"='column value2') then "table name"."column name" end

or

case when 2 statement

and

Case when 3 statement

or Case when 4 statement

therefore user wants only the bold text value(table name"."column name) to be displayed only not the calculation at front end.

I can think of Narrative view but how to do that exactly? Please help.

Thanks..

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 11 2013
Added on Aug 13 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #prompt
24 comments
4,092 views