Allowing for Multiple Values Returned via a List

If you need a supported parameter to return a comma separated list of values for an IN clause in the data template, do the following:

In BI Publisher, set the parameter type to Menu. This will allow you to link it to a list.
Create a hard-coded list or a query to get the possible values for the parameter.
See examples of this in BI Publisher's pre-packaged reports.
Select the list of values you just created for the parameter.
Check the Multiple Selection option for the parameter.

If a parameter allows for multiple selection, P6 allows selection of multiple values from the list or allows users to continue to assign values without closing the list. When the return value appears, parameter values are comma-delimited.

Related Topics