Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 51 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle BI EE OTBI Query multi Select query
MaheshT
Rank 1 - Community Starter
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.
0
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.
0
