Auto-Complete Functionality in OBIEE 11g

OBIEE 11.1.1.6 provides auto-complete functionality for prompts, which, when enabled, suggests and highlights matching prompt values as you type in the prompt selection field. You configure the auto-complete functionality to be case-sensitive or case-insensitive, and then specifies the matching level.  The matching level determines how OBIEE matches the column’s values to what you type in the prompt.

Enabling Auto-Complete

1. Navigate to the path  $Middleware_Home\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1.

2. Make a copy of instanceconfig.xml.

3. Open the file instanceconfig.xml.

4. Add the following lines in between the <ServerInstance> </ServerInstance> tags.

     <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>

5. Save the changes.

6. Restart the OBIEE 11G Services.

7. Log in to OBIEE.

8. In Answers create a prompt.

9. Select User Input as Choice List and check Enable user to type values.

10. Type the values in the prompt and you can observe that the prompt suggests and highlights matching prompt values as the user types in the prompt selection field.

Metalink Reference Notes:
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1461398.1