Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Obiee presentation variable in a DDR report using a case statement.
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.
Answers
-
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
0