OBIEE 11g – How To Remove Null Values In Prompts After 11.1.1.9.0 Upgrade


 When you have a prompt that shows a “drop-down” list to select from, it can include a “null” selection. 

This can be suppressed by a single configuration setting for all prompts:

  •  Open your “instanceconfig.xml” file, and locate this entry:
    •  <ShowNullValueInPromptsWhenDatabaseColumnIsNullable>always</ShowNullValueInPromptsWhenDatabaseColumnIsNullable>
  • Change “always” to “never”
  • Save the file
  • Restart OBIEE

 

Advertisements

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