Bi Publisher Enterprise will not accept multilple values

Question

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

SriniVEERAVALLI · Answer

Wow thats nice.

SriniVEERAVALLI · Answer

Cool.

mark as correct and close this post

deahayes · Answer

Thanks I removed the NVL, it works now.  org_id IN (:p_org_id)