Bi Publisher Enterprise will not accept multilple values

deahayes

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

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) !!!!

deahayes

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

SriniVEERAVALLI

Cool.

mark as correct and close this post

SriniVEERAVALLI

Wow thats nice.