Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Oracle BI EE OTBI Query multi Select query
I have a query that was written as a Data Analysis in Oracle OTBI, and I am using it inside of BIP Data Model and I am structuring parameters for the Oracle BI EE logical SQL. The parameter :P_Period I would like to use as an optional multi-select parameter in the WHERE clause, where the user can either select 1 or more Period,
or
they can leave it set to All so that it doesnt filter items.
What do I need to update my syntax to for this to work? Thanks in advance.
Answers
-
Hi Mahesh,
Welcome to Oracle Analytics community.
You can try like below:
AND (paaf.organization_id IN(:Department) OR (LEAST(:Department)IS NULL))
Thanks.
2 -
This seems to work:
AND (paaf.organization_id IN(:Department) OR (LEAST(:Department)IS NULL))
Why is this marked as incorrect answer?0 -
Thanks for confirming. It has always works well for me.
Oracle BI EE OTBI Query multi Select query — Oracle
Can you explain what issue you are facing?
Thanks.
0
