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

Simple Summary of Fundamental Essbase Calcs Method for those FCCS folk new to Essbase

edited Dec 1, 2017 6:13PM in Financial Consolidation and Close 2 comments

Summary

This just summarizes the order in which Essbase calcs should be executed

Content

An Essbase Block is comprised of a combination of all the dense dimensions (In FCCS currently just the Accounts dimension). There is then a block created for each populated sparse dimension member.

When data is initially loaded only level 0 sparse dimension members are populated. Some simplistic graphics follow which attempt to show this.

Essbase calculations are made most efficient by trying to ensure that at every step the least possible blocks are being “touched”!

As a rule data should be loaded at leaf node level, Operator calcs done within the Dense Dimensions (in FCCS the “Accounts” dimension) as this will not create any new blocks, only make the existing blocks more dense; and finally the Sparse Dimensions get aggregated, which will create all the relevant sparse dimension blocks.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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