Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Bi Publisher errors on multiselect
Hello all,
I created a report, with parameters, I am now trying to change the options on the data model parameters to Multiple 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????
Answers
-
what does the XML file say when you view the Engine Log?
0 -
Hi ,
Use below condition in data model query
(org_id is null or org_id in nvl(:p_org_id,org_id)) ,let me know any issues ,Thanks
0 -
The query in the xml output might be your issue ... try taking out the special characters to start and the where clause doesn't have the proper syntax for multivalue as your original post states.
0