PFTBI Data Mismatch Between Essbase Cubes and OBIEE Reports (Doc ID 1496635.1)

Last updated on OCTOBER 08, 2012

Applies to:

Oracle Financial Services Profitability Analytics - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
PFT BI

Symptoms

On Oracle Financial Services Profitability Analytics (PFTBI) 5.6, when attempting to reconcile the data between the Essbase cube and OBIEE, there appears to be some inconsistencies for the PFALDGFA Cube.

ACTUAL BEHAVIOR
In the Essbase server, when viewing the PFALDGFA Cube in Preview Data, the Overall value for the Amount measure is 75374. However, in the OBIEE report, Financial Accounting, Income Statement by Time shows a different amount:

2012 Quarter 1
Interest Revenue: 102,368.00

EXPECTED BEHAVIOR
Expect the amounts between the Essbase cube and the OBIEE report to be the same.

STEPS
The issue can be reproduced at will with the following steps:

1. Check the PFALDGFA cube data.
2. Check the OBIEE reports data for Financial Accounting: Income Statement by Time

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