OBIEE 11G Auto Complete Prompts

Oracle BI EE provides auto-complete functionality for prompts, which, when enabled, suggests and highlights matching prompt values as the user types in the prompt selection field. Auto complete is only available for the Choice List as user input and when checked the “Enable User to Type Value” option.

Configuring Auto Complete at system level.
Open the instanceconfig.xml file for editing
Location: D:\OBIEE11g_HOME\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
Take backup copy
Right click and click on Edit
Insert the below code between the    <ServerInstance>…….. </ServerInstance>
<Prompts>
<MaxDropDownValues>256</MaxDropDownValues>
<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>
<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>
<AutoCompletePromptDropDowns>
<SupportAutoComplete>true</SupportAutoComplete>
<CaseInsensitive>true</CaseInsensitive>
<MatchingLevel>MatchAll</MatchingLevel>
<ResultsLimit>50</ResultsLimit>
</AutoCompletePromptDropDowns>
</Prompts>
Save your changes and close the file
Restart Oracle Business Intelligence.
The auto complete functionality is enabled at the system level, but the dashboard designer or BI Reports developer can exclude the auto-complete functionality from dashboards, and user can turn auto-complete off by using the “My Account dialog”.
After implementing the auto complete functionality at system level, you can enable or disable at dashboard properties level

And by user level in my account settings.

The results in Prompts for auto complete are shown below

These are not case sensitive, you can type in any case (this is part of the above code)