Categories
- All Categories
- 10 Oracle Analytics Sharing Center
- 13 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to display selected parameter values in a multi-select parameter?

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)
Answers
-
I think you directly use the tag in the RTF/XLS.
0 -
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?>)
0 -
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
0