Displaying all values of the dashboard prompt in OBIEE

Post date: 12-Apr-2010 10:12:10

In order to over come that we have to add the following entry in instanceconfig.xml(OracleBIData\web\config\instanceconfig.xml)

<Prompts>

<MaxDropDownValues>750</MaxDropDownValues>

</Prompts>

Impact:

Please note that providing huge values like 1000, 10000 will have performance impact to the Dashboard. Try using multi-select instead of drop-down