How to display selected parameter values in a multi-select parameter?

Question

I have a Parameter that allows multi-select. For example: P_GENDER.

The user can select - "M','F', 'All'

If the user selects 'All', then the report should show All

If the user selects 'M' and 'F', then the report should display M, F

I am not talking about the 'where' clause. I am asking - how to show the Parameters that the users have selected (as part of the header)

Simonab-Oracle · Answer

Hi @la_felA,

I would really appreciate if you could confirm the following additional details:

1. Provide the steps you have taken to define the parameters value.

E.g.

*  Create a LOV.
* Define a few values(e.g. 'M', 'F')
* Create a parameter.
* Assign the LOV to a report

2. Does the report display the parameter values selected?

3. What is the BI Publisher version you are currently using?

4. If you create a BIP report using parameters as Muti select in the BI Publisher report, the BI Publisher report works fine as expected in the BI Publisher?

5. Is your requirement to embed the BIP report in the Dashboard and you cannot create Muti-Select prompt in Answers using the presentation variable created in the BI Publisher report?

Than you,

Simona

Federico Venturin - Oracle · Answer

Hi @la_felA ,

Parameter values are included in the XML result set when the data model is executed. You can print them in your template as any other field in the result set (e.g. <?P_GENDER?>)

Abhilash K - Deloitte USI · Answer

I think you directly use the tag in the RTF/XLS.