OBIEE Enabling AutoComplete and Never Show Null for Prompts

Since 11.1.1.6 Enabling AutoComplete function is supported by modifying InstanceConfig file.

This setting when set to true turns auto-complete on, which means that the Prompts Auto-Complete field is displayed and is set to On in the My Account dialog and in the Dashboard Properties dialog.

AutoComplete

The link to instanceconfig.xml can be found: \instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Add the following code before <\ServerInstance>

  <Prompts>
    <MaxDropDownValues>256</MaxDropDownValues>
    <ResultRowLimit>65000</ResultRowLimit>
  <AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>
    <AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>
    <AutoCompletePromptDropDowns>
      <SupportAutoComplete>true</SupportAutoComplete>
      <CaseInsensitive>true</CaseInsensitive>
      <MatchingLevel>MatchAll</MatchingLevel>
      <ResultsLimit>50</ResultsLimit>
    </AutoCompletePromptDropDowns>   
  </Prompts>

Further reading of AutoComplete can be found:

Santosh Kumar Gidadmani’ Blog

If you are using 11.1.1.7 or above, I suggest to also add before </Prompts> the following:

<ShowNullValueInPromptsWhenDatabaseColumnIsNullable>never</ShowNullValueInPromptsWhenDatabaseColumnIsNullable>

This would specify whether to show the term “NULL” at runtime in the column prompt above the column separator in the drop-down list when the database allows null values.

You can use the following settings. Note that always is default.

  • always — Always shows the term “NULL” above the column separator in the drop-down list.
  • never — Never shows the term “NULL” in the drop-down list.
  • asDataValue — Displays as a data value in the drop-down list, not as the term “NULL” above the separator in the drop-down list.

Santosh has also talked about how to tackle this for versions before 11.1.1.7 and can be viewed here: Santosh’s Blog

That’s it for today!

Advertisements

Author: Steve Yeung

Being in the EPM & BI field for more than 8 years, it's about time I contribute to newcomers! As a founder of MondayBI.com I wish to give you all the help I can. Feel free to give any suggestions or questions. Hope you will all enjoy this blog! William Wong Essbase Certified Specialist OBIEE Certified Specialist

1 thought on “OBIEE Enabling AutoComplete and Never Show Null for Prompts”

  1. Woah! I’m really loving the template/theme of this site.
    It’s simple, yet effective. A lot of times it’s tough to get that “perfect balance” between user friendliness and visual appeal.
    I must say that you’ve done a fantastic job
    with this. Also, the blog loads extremely fast for me on Safari.

    Exceptional Blog!

    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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s