Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 10 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 64 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Multiple Default Values in Multiple selection Menu

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.
Answers
-
click on the option multiple selection use comma or semi colon
0 -
-
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
0 -
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 )
0 -
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?
0 -
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
0 -
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.
0