Oracle Analytics Publisher

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

Multiple Default Values in Multiple selection Menu

Received Response
317
Views
7
Comments
Rank 1 - Community Starter
edited May 14, 2024 3:02PM in Oracle Analytics Publisher

Summary

Multiple Default Values in Multiple selection Menu

Content

I need to set multiple default values for multiple selection menu control in BI publisher report parameter. Is it possible somehow?

Values in dropdown menu are populated from Sql.

Thank you.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    click on the option multiple selection use comma or semi colon

  • Rank 6 - Analytics Lead

    In addition to ​ where u select the parameter type menu at the bottom u have an option

    image

  • Rank 6 - Analytics Lead

    There is an option where you can enter default values for parameters , there you can list what the default values can be.. but with this option you may loose the option of selecting 'ALL' 

    Hope this helps

    --YG

  • Rank 6 - Analytics Lead

    you can try with coma separated "," or semi-colon ";" separated .. you may have to try this out on your query first and then implement the same on BI Publisher (in the default value box )

  • Rank 1 - Community Starter

    Thank you for your prompt response, as I have said above, I need to give more than 1 default values. Do you have any idea how it can be achieved?

  • Rank 1 - Community Starter

    Hello Karim,

    Did you have any luck figuring this out? I am also interested in finding a solution. I also can only figure out how to add one default option.

    When you run the data model having first manually selected multiple values from the list the global options summary are in brackets [MenuOption1,MenuOption2]. I tried entering this into the default value for the parameter, but it did not work.

    Let me know if you've found a solution.

    Matt

  • Rank 1 - Community Starter

    Fusion Apps, How to Transmit Multiple Default Values In A BI Publisher Menu Prompt, Multiple Deault Values in Data Model Parameter (Doc ID 2112922.1)

    For strings you need to use default mask, "value","value" and finally the multiple parameter will work fine.

Welcome!

It looks like you're new here. Sign in or register to get started.