OAC Parameter Initial Value Can't be Blank

User_AGDJ1

I am following the instruction here https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/create-parameter.html .

In the Initial Value field, I don't want to use an initial value, I select value and leave the value blank. I am getting following error message.

If initial value can't set to be blank, is there other way for me not set initial value and to use all values?

Anirban Basu-133546

In the initial value can you use Logical SQL Query to bring all the values

User_AGDJ1

What if all values have over 30+ items?

And in expression filter what should I put as default value in this case?

@parameter("parameter name")('default value')

Gabby Rubin-Oracle

Allowing empty initial value was introduced in the May update. In your example, since you selected 'Allow multiple values', the system created a dummy first value (which is empty), just delete that value using the X next to it, and you should be fine. Make sure that you are on the May update.

Parameters with 'Allow Multi Select' can have multiple values returned in the initial value logical SQL; a single select will take the first one if multiple values are returned.

Not sure what was the question from the last user, but questions are better addressed in the Forum vs. the Idealab.