OBIEE 11g - The Line of Pareto Graph in the Pivot View Shows Incorrect Percentages (Doc ID 2111446.1)

Last updated on JANUARY 31, 2017

Applies to:

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


You are using Pareto Graph in the Pivot view.
and you are trying to set the "Show Data Labels : Always" in the Graph properties > Titles and Labels > Format:Data Labeles > Display Options.

In the following documents, the Data Labels for line of Pareto Graph in the Pivot view should be shown a cumulative total of the percentages.
[Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition]
What Types of Graphs Are Available?
Table 3-2 Graph Types

  Is a form of bar graph and line graph that displays criteria in descending order.
  In this graph type, the line shows a cumulative total of the percentages.

But, the line of Pareto Graph in the Pivot view shows incorrect percentages when selecting "Show Data Labels : Always".

The Reproducible Case with using SampleSalesLite as follows;
1. Login to BIEE
2. New > Analysis > Sample Sales Lite
3. In the Criteria tab. Drag&Drop the following columns.
  - Column[Per Name Year](Edit Formula: "Time"."Per Name Year" )
  - Column[Brand](Edit Formula: "Products"."Brand" )
  - Column[LOB](Edit Formula: "Products"."LOB" )
  - Column[Product Type](Edit Formula: "Products"."Product Type" )
  - Column[Revenue](Edit Formula: "Base Facts"."Revenue")
  - Column[Revenue%](Edit Formula: "Base Facts"."Revenue")
     * change Column Heading from Revenue to Revenue%


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