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

Can we Set the Multiple default values for BIP Report

Rama Krishna Annam

Example:-

Set the default value for the parameter "Person Type" to the following:

Selected: Employee, Expat, Fixed Term Employee, Intern, Retirement Term Employee, Specified Term Employee, Third Party Employee.

Not Selected: DPP/DPC contracts in Czech Republic – ONLY, Seasonal Worker

Current Behaviour:

1)Default Value (Single Value) is working as Expected.

2)Default Value (Multiple Values) are not working as Expected.

Expected Behavior:

1)Default Value (Multiple Values) should work.

Find more posts tagged with

Fusion HCM Analytics

Accepted answers

All comments

Basavaraj Navalagi

Put each value separated by ; and try

Max W

Hi @Basavaraj Navalagi ,

I've come across this thread as I'm trying to do this now.

I need an assignment status default values to show as:

ACTIVE, SUSPENDED

I can get it to work with one. When I use the ; as you have suggested. It doesn't then use a default value. Is this format correct?

ACTIVE;SUSPENDED

Or should there be some other format? I've tried the above and no luck. Also with spaces.

Thank you.

IK kal

Hi @Max W and @Basavaraj Navalagi @Rama Krishna Annami came across this thread but , and ; both doesn't work for me as well did you guys came across with any solution for this to add multiple default values ?

Thanks

Orange

Hi @Rama Krishna Annam ,

If I understand your question correctly then it is posted in the wrong forum because as per my understanding your question is not regarding Fusion Analytics Warehouse HCM but regarding HCM BIP. I suggest to move it to the HCM Reporting and Analytics forum (https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm) and add a tag 'BI Publisher' to your post.

In the meantime, you can find an answer your question on https://docs.oracle.com/cd/E23549_01/bi.1111/e13881/T527073T560157.htm#addlov. I hope this helps.

Kind regards

Erling

Hi Did you got the solution for this?

MandeepGupta

Hi @Erling ,

This should be possible. You can pass multiple values in the default section in below format:

"Test1", "Test 2"

Check the exact details on below link:

How to pass multiple values as default for an Input parameter in BI Report?

Thanks.

Ashish-Oracle

Hello @Rama Krishna Annam

This query is more on the BIP side of things. I would suggest you post this query in the BIP forum for more accurate responses.

https://community.oracle.com/products/oracleanalytics/categories/bi-publisher