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

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

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.

-Office,
-Product,
-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.)

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