Bi Publisher errors on multiselect

deahayes

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????

Thomas Dodds

what does the XML file say when you view the Engine Log?

Venkat Thota - BIP

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

Thomas Dodds

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.