My Oracle Support Banner

OBIEE 11g | 12c: Scatter Graph doesn't Honor the Minimum Value When Maximum Value Set to Zero in Axis (Doc ID 2419248.1)

Last updated on MARCH 15, 2019

Applies to:

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


When using a Scatter Graph, the Minimum value you specified may not work if you set the Maximum Value to 0 (Zero) in Axis.

This symptom is also reproducible in version.


You can confirm this symptom with "Sample Sales Lite" as following:

1. Create an analysis as following:

<Selected Columns>

"Base Facts"."Revenue"
"Calculated Facts"."Actual Unit Price" * -1


Actual Unit Price * -(1)  is greater than or equal to -20

2. Add a Scatter Graph in Results tab and config it as following:

<Scatter Graph>

Horizontal Axis: Revenue
XY (Vertical Axis): Actual Unit Price * -1
Vary Color By: Product

<Graph Properties>

Scale > Vertical Axis >
    Axis Limits: Specify
    Minimum: -10
    Maximum: 0

3. The minimum value returns "-14" in the vertical axis of Scatter Graph instead of "-10" which you specified in Graph Properties as a Minimum.






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

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