PFTBI Data Mismatch Between Essbase Cubes and OBIEE Reports
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
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.
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
Expect the amounts between the Essbase cube and the OBIEE report to be the same.
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
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