OBIEE 11g Configuration for Auto Search and Auto Complete for Prompts

The auto search and auto complete are the great futures of prompts in OBIEE 11g. End users are becoming impatient to use these feature in almost all the dashboard pages.

A typical customer request is as follows

Could the prompts be changed so we can type in a value and it comes up, rather than having to search? Same goes for all reports

This blog is an attempt to list down configuration changes required to achieve auto search and auto-complete features

Manual Configuration

Open the instanceconfig.xml file for editing,

ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsn

For example:

\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

The instanceconfig.xml entries for Prompts, which includes Auto Search/Complete tags, are listed below.  The drop down values in the prompt are limited by </MaxDropDownValues> tag.

<ServerInstance>

<Prompts>

<MaxDropDownValues>256</MaxDropDownValues>

Auto Apply ---------------------------------------------------

<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>

Auto Search ----------------------------------------

<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>

Auto Complete ----------------------------------------

<AutoCompletePromptDropDowns>

<SupportAutoComplete>true</SupportAutoComplete>

<CaseInsensitive>true</CaseInsensitive>

<MatchingLevel>MatchAll</MatchingLevel>

<ResultsLimit>50</ResultsLimit>

</AutoCompletePromptDropDowns>

</Prompts>

</ServerInstance>

Version Limitation

The Auto Search is supported from OBIEE 11.1.1.6.0 and above. For earlier versions I would suggest to upgrade to latest version of OBIEE 11.1.1.7.1, as I believe this version is more stable.

I hope you find this information useful.