BI Publisher data model with multi-select parameter
Hi, I have a BI Publisher data model that gets data from an Oracle function in a package. This works fine so long as the parameters are either NULL or a single value.As soon as I select more than one value for a parameter, the data model cannot execute the function. The error is "Failed to load XML" & "End tag 'span' does not match the start tag 'img'. "
Looking into the "Data Engine Log", it appears that when you have a multi-select parameter, BI creates multiple parameters on the fly and sends each one to the query. How is one supposed to use a parameter set up as "Multiple Selection" when using a stored proc/function?
0