1 Reply Latest reply on Apr 2, 2018 1:49 PM by Christian Berg

    Obiee presentation variable in a DDR report using a case statement.

    user7326746

      I am trying to do an item filter within a DDR based on a presentation variable

      When the variable is NUll - I need to display all the items

      When the variable is not null I need to display the values passed in.

       

      When I try to use a case statement it works for the NULL Value (all items are displayed)

      But Fails when a selection list is sent in.

       

          and d.segment1 in

          (case

                when d.segment1 in is not null then (@{ITEM_SELECTION}['@']{''})

           else

             d.segment1

           end)

       

      I have also tried this:

      and d.segment1 in decode((@{ITEM_SELECTION}['@']{''}),null,d.segment1,(@{ITEM_SELECTION}['@']{''}))

       

      Any Suggestions would be welcome.

        • 1. Re: Obiee presentation variable in a DDR report usinf a case statement.
          Christian Berg

          user7326746 wrote:

           

          I am trying to do an item filter within a DDR

          ...

          Any Suggestions would be welcome.

           

          1.) Use the tool as it was designed

           

          2.) Don't use DDR

           

          3.) If you like writing SQL and don't want to model things then use a different tool

           

          tl;dr most such use cases are simply down to not understanding how OBI works and are as a result wasting money and effort while at the same time producing hacks and workarounds which are overly complex, hard to understand, eliminate vanille functionalities and a total waste of money. Plus...have fun testing these things when upgrading