Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
All Column Values in BI Publisher
Answers
-
Hi Sherry,
where model
in (:P_MODEL) or '*)nqgtac(*' IN (:P_MODEL || '*)nqgtac(*')
I have put the following condition, but still doesn't work. I am getting the same error.
0 -
Any luck on this issue. I am facing the same issue when 'All column values' are passed from Dashboard prompt to BI Publisher report.
Appreciate any inputs.
Regards,
SG
0 -
Hi,
Maybe you have null values being passed? how's your query handling the nulls?
Try something like:
...
WHERE LEAST(:P_MODEL) is null or '*)nqgtac(*' IN ((:P_MODEL || '*)nqgtac(*'))
...
Regards,
Youssef
0 -
You have to handle data model query to accept "all values" and "multiple values" ,
Also what is your source for bip data model ?
0 -
'All' is equivalent to '*' for BI Publisher parameters.
0