My Oracle Support Banner

NULL Value Disappears When Selecting 'Limit values by' Filtering Option In Prompts (Doc ID 2716546.1)

Last updated on OCTOBER 05, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.200414 and later
Information in this document applies to any platform.

Symptoms

NULL value disappears when turning on 'Limit values by' choice list values in OBIEE 12c prompt. This is observed only when User Input is 'Choice List' in Prompts.

Steps to verify

  1. Create prompt with 2 columns where NULL Value is present in data for the columns.
  2. In the 2nd column prompt, choose 'Choice List' in User Input.
  3. In Choice List Values, select 'Limit values by' and choose the 1st column.
  4. In Display section, select the 2nd column where 'Limit Values By' is applied.
  5. Null is not displayed.

Changes

Upgraded from 11g to 12c.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.