Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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
-
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 -
click on the option multiple selection use comma or semi colon
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