1 2 Previous Next 24 Replies Latest reply: Aug 14, 2013 12:42 PM by 995724 RSS

    How to hide filter view calculations in answers in obiee 11g?

    995724


      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..

        1 2 Previous Next