BI Reports In Prod Issues - Opportunities Duplicated When Using Pipeline Facts.
Last updated on JUNE 30, 2016
Applies to:Oracle Fusion Sales Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms