% Acts as All Choices in OBIEE Prompts.

If we put % symbol in Default to ->Specific value box of a prompt, it will act as All choices.
Ex : In the below prompt, I have used % in   Default to ->Specific value box.








Now create a report.




Now add both prompt and report to dashboard and check.

Note : We have used % symbol in Specific value box and we get All Choices in dashboard as default value.

So, as we do not have All choices option in Default to drop down for Edit Box control, we can use the this strategy to set All choices.



Let's check in dashboard.



That is  by default our prompt is sending all values to filter of the report.