Oracle BI EE Report:Configure 'Grand Total'[Column Measure-Aggregation Rule] To Show 2 Decimal Value (Doc ID 2125166.1)

Last updated on APRIL 19, 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

On :  11.1.10.0.0 version, Analytics

ACTUAL BEHAVIOR  
---------------
Customer has a custom field of type Currency but without Decimal places.
When a report is built and an aggregation applied, the aggregated value shows 3 decimal places.
Even on applying a Data Format on the Column to specify 2 decimal places, the aggregated value shows 3 decimal places.

EXPECTED BEHAVIOR
-----------------------
The Aggregated value should use the Data Format specified for the column and show 2 decimal places.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Select a Standard Object (say Opportunity) or create a Custom Object
2. Create a new Custom Field of type Currency but without Decimal Places specified.
3. Expose the field on SUI and enter a value with 3 decimal places
4. Build an Analysis in BI on the Custom Field and apply an aggregation rule of Sum on it
5. Apply a Data Format on the column and specify Currency with 2 Decimal places.
5. Run the Report in BI by clicking on 'Results' tab.

Observe that even though the Data Format of Currency with 2 Decimal places is applied on individual values for each record, the Aggregated Value of the custom field displays the value with 3 decimal places.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the Data Format is not applied on BI Report for Aggregated Custom Fields.

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