My Oracle Support Banner

OBIEE 11g: Minus Data is Incorrect When Using Trellis (Doc ID 2281774.1)

Last updated on MARCH 19, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


When scale type is changed from "dynamic" to "specified," or changing the Vertical Axis Title or Horizontal Axis Title, Minus data turned incorrect in trellis graph view.

For example:
1. Using Sample Sales Lite, create the following analysis.

-Revenue - (Billed Quantity + Discount Amount * 25)
  * In order to display the Minus data

Add Filter:Office is equal to / is in Montgomery Office

2. On the Results tab, add a trellis view.

Rows:Office, Product

3. Correct data in the Trellis view.
(The center of the axis is 0, the left side is a negative number, the right side appears as a plus number.)

However, once the scale type is changed from "dynamic" to "specified",

Alternatively,change the Vertical Axis Title or Horizontal Axis Title,

The Trellis of negative value turned (bar length and 0 reference) collapses.



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.