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 Oracle Analytics Server, 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 Oracle Analytics Server'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 will allow selecting multiple values from the list or allow users to continue to assign values without closing the list. Values will have commas to separate parameters when the return value appears.