Search This Blog

Tuesday, June 5, 2012

CUBE
===========
All about FAH Cube =Fusion + GL = GL3
For those of you that have forgotten algebra, GL3 is GL cubed, that's an Oracle Essbase cube to be precise.  The idea behind incorporating the cube into Fusion GL was to give users the powerful  multi-dimensional analysis capabilities,
when I started this FAH learning i was bit confused about how and what this CUBE is all about .here is the concept ,The cube contains real-time balances.  Meaning that when a journal is posted, the balances in the cube are updated.   And not only the detailed balances, but the balances for all levels of the hierarchies over different dimensions too.  In short, this means that there's no longer  any processes needed to calculate summary balances.  Oh, and, you can have multiple hierarchies or versions of hierarchies over any dimension, and they're all updated during posting.
Still not convinced?  There's more.....Smart View, Financial Reporting, Allocations, Account Monitor, and Account Inspector all powered by cube.




With the acquisition of Hyperion, Oracle got the Essbase product and they integrated the EssbaseCubes into Fusion Applications General Ledger to store large quantities of data in a way that can be accessed rapidly and also to manage and organize this data for intuitive and immediate decision support.

With the Fusion GL cube, the balances are instantly available for any dimension in the Chart of Accounts, at any level of summary or detail, with the latest real-time data from the posted journals.
It’s like a data warehouse, and it is fast and powerful for data analysis and retrieval. But unlike a data warehouse, balances in the cube are updated in real time whenever a journal is posted in General Ledger, so they always show the most up-to-date and accurate financial information.
More features were added to Fusion Applications General Ledger such as: Slicing and Dicing, Pivoting, Expansion, Drill-down, Real Time, a General Accounting and Account Monitor Dashboard, a new Close Status Monitor which enhances the visibility of the status of the close process (which is something we always asked for in EBS), and the new Oracle Transactional Business Intelligence (OTBI) among others which will be presented in the future communications are making this product the best of breed.


 Over the next few weeks, I'll go into more details around what makes Fusion Financials better and more on the power of the cube.  In the meantime, if there's something that you would like to know, leave a comment and we'll put it on the list of topics for future posts.
for more details of Cube refer this link
http://www.oracle.com/technetwork/middleware/bi-foundation/studio-094678.html


No comments:

Post a Comment