11G BI Publisher: NULL Values On Line Graph Are Shown As 0 Instead Of NULL (Doc ID 1579476.1)

Last updated on OCTOBER 04, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.6.0 to 11.1.1.7.0 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When creating a graph in Answers then it ignores NULL values and is displayed correctly.

When the same graph is recreated in BI Publisher Layout Editor additional formula is added (default: Summation) and it is not possible to select "No Formula".

This changes the NULL values to 0 and then makes the graph incorrect

Changes

 upgrade to BIP 11.1.1.6 or BIP 11.1.1.7

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms