Expand Limit of Number of Values in Dashboard Prompt

In OBIEE 11g when dashboard prompt has values over 100, the dashboard prompt tends to do paging of these values. It will by default show you 100 values and to see more prompt values you need to click on ‘Search’. Which in turn opens pop window which shows all values.

To avoid this and to see all values of prompt within drop down itself we need to make few changes in ‘instanceconfig.xml’ file. It’s location is,

/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/

We need to add following code in this file,

<Prompts>

      <MaxDropDownValues>1000</MaxDropDownValues>

 </Prompts>

You can add any number as per your requirement.

This will display all values of prompts within drop down without any paging.