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

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.