How to enable Auto-Complete search for Prompts OBIEE Analysis

To enable auto-complete for prompts add the below tag in instanceconfig.xml file

1. Navigate to the below path

OBIEE 12c :

$ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/

OBIEE 11g :

$MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication

2. Open the instanceconfig.xml file

3. Add the below in <ServerInstance></ServerInstance> tag

<Prompts>

<MaxDropDownValues>1000</MaxDropDownValues>

<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>

<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>

<AutoCompletePromptDropDowns>

<SupportAutoComplete>true</SupportAutoComplete>

<CaseInsensitive>true</CaseInsensitive>

<MatchingLevel>MatchAll</MatchingLevel>

<ResultsLimit>1000</ResultsLimit>

</AutoCompletePromptDropDowns>

</Prompts>

4. Save and close the file

5. Restart the obiee components

6. Login to OBIEE with the Admin user

Go to My Account 

Change Prompts Auto-Complete to “On”

Click OK

7. Now check in the prompts auto search will work