Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
661
Views
3
Comments
la_felA
la_felA Rank 1 - Community Starter

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)

Tagged:

Answers

  • Abhilash K - Deloitte USI
    Abhilash K - Deloitte USI Rank 5 - Community Champion

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

  • 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?>)

  • Simonab-Oracle
    Simonab-Oracle Rank 4 - Community Specialist

    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