Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Difference between data in Essbase Cube and Fusion Transactional data — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Difference between data in Essbase Cube and Fusion Transactional data

Received Response
32
Views
1
Comments
edited May 28, 2020 10:10PM in Financials – General 1 comment

Summary

Trying to illustrate the difference between what data is stored in the Financial Essbase Cube and what is in the Fusion transaction database.

Content

Hello Everyone. I am wondering if anyone knows, or has, some form of documentation to illustrate the difference between what data is stored in the Financial Essbase Cube and what is in the Fusion transaction database. I am an I.T. member, not a member of our finance team, but I do have some financial knowledge.

The way I currently understand it is that the Essbase Cube contains General Ledger Balances that are only updated after months are closed in modules. The Fusion Transaction database contains all of daily credit/debits to the module Sub-ledgers. The different reporting tools have access to the different locations.  Analysis, BI Publisher, Smartview look at Transaction data. Financial Reporting Studio looks at Essbase data.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!