nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Multiple Default Values in Multiple selection Menu

Karim Sabah

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.

Find more posts tagged with

Accepted answers

All comments

YGUTTIKONDA

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

Dir_Pal

click on the option multiple selection use comma or semi colon

YGUTTIKONDA

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 )

Karim Sabah

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?

Dir_Pal

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

Matthew Day

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

Rajesh.Vadlamani

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.