Dashboard Prompt Default Values Limit

User_2NI9B

Hi All.

Please see below Oracle's recommendation on dashboard prompt:

A prompt with a drop down list in OBIEE is limited to 256 values by default. If you want to modify the drop down list to see more or less values then there is a configuration parameter that you can change to increase the number of values shown up to 1000. You can set it to any value up to 1000, including values less than the default of 256.
To implement this change please do the following

Edit the instanceconfig.xml file located at [$FMW_HOME]/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

If Prompts tags are not in the file then manually add so as shown below. Then add the MaxDropDownValues parameter in between Prompts tags and make sure this section of code should be between the ServerInstance tags in the file.

For Example:

<Prompts>

<MaxDropDownValues>1000</MaxDropDownValues>

</Prompts>

</ServerInstance>

Using this the above solution, dashboard prompt indeed showing more than 256 values now. But what about the default values of a prompt? Our prompt has 450 values which we see in the prompt without the need to click "More" button. Even though all 450 values were pushed in as default values, when we run the dashboard, we see the dashboard runs for only 256 values giving incomplete results.

Is there any other parameter where we can increase the number of default values of a prompt?

Thanks

User_2NI9B

Answer to my question:

1. Add or modify the following tag <MaxDefaultValues> into instanceconfig.xml and set a proper value (in the below example, it is set to 1000).
   
   
   <Prompts>
   <MaxDefaultValues>1000</MaxDefaultValues>
   <MaxScrollValues>100</MaxScrollValues>
   <MaxDropDownValues>10000</MaxDropDownValues>
   </Prompts>
   
   
   
2. Then, restart Presentation Service.