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 11.1.1.7.150714 and later
Information in this document applies to any platform.

Symptoms

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

 Pareto
  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%

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