My Oracle Support Banner

OAS 5.5 : SHOWNULLVALUEWHENCOLUMNISNULLABLE DOESN'T WORK AS SUGGESTED ON PROMPTS (Doc ID 2703105.1)

Last updated on AUGUST 20, 2020

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
Null values showing up in prompts even after using the tag that used to fix it previous releases of OBIEE

Problem Description
---------------------------------------------------

As suggested in Admin guide, tag ShowNullValueWhenColumnIsNullable is not working:-

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/configure-prompts.html

<ShowNullValueWhenColumnIsNullable>never</ShowNullValueWhenColumnIsNullable>

Changes

 Upgraded to OAS 5.5 or new install of OAS 5.5

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.