BI Reports In Prod Issues - Opportunities Duplicated When Using Pipeline Facts. (Doc ID 2151116.1)

Last updated on JUNE 30, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms


The Totals rows are not summing correctly the values in a Measure column.
For example, you have Measure columns containing the counts of Won Revenue, by "Open" Sales stages.

You are grouping these counts by Sales Representative, or some other entity.
After using the "Totals" configuration to display Totals for this entity, the Total values are larger than the sums of measures across the entity.


Steps followed:

The issue can be reproduced with the following steps:
1. Edit the Layout of the analysis in question.
2. Ensure that the selected Aggregation Rules for the column in question are:
  - "Report-Based Total (when applicable)" and "Default"
3. Under the desired column to group by (e.g. Sales Representative), click the Sigma icon and select "After".
4. Run the analysis.



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