OBIEE 11g: Minus Data is Incorrect When Using Trellis
Last updated on JULY 17, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.140527 to 220.127.116.11.170418 [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.
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.
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.
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