Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 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
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