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.

[Deleted User]

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