ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 358,305 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

OBIEE 11g – Auto Complete Functionality in Prompts

Posted by Santosh Kumar Gidadmani on November 23, 2014

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.

image1

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

image2

And by user level in my account settings.

image3

The results in Prompts for auto complete are shown below

image4

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

image5

image6

 

Thanks,

Santosh

 

Advertisements

One Response to “OBIEE 11g – Auto Complete Functionality in Prompts”

  1. wahid said

    Thanks for sharing this info.Its a cool feature …

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: