Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 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
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Bi Publisher Enterprise will not accept multilple values
deahayes
Rank 4 - Community Specialist
Hello all,
I created a report, with parameters, I am now trying to change the options on the data model parameters to Muliple Selection, Can select all, and All values passed. However when I try to view data I get an error. "XML failed" when I remove the options of multiple select it works. Also my data model query can accept multiple values for example, org_id IN Nvl(:p_org_id, org_id)
Any ideas whats going on????
0
Answers
-
is your query correct? for instance p_org_id is null then what value query should take from org_id?
example, org_id IN Nvl(NULL, org_id) !!!!
0 -
Thanks I removed the NVL, it works now. org_id IN (:p_org_id)
0 -
Cool.
mark as correct and close this post
0 -
Wow thats nice.
0