MEMBER CALCULATION ORDER

MEMBER CALCULATION ORDER

When you perform a default calculation (CALC ALL) on a database, Essbase calculates the dimensions in the following order:

If both a dimension tagged as accounts and a dimension tagged as time exist, and if formulas are applied to members on the account dimension, Essbase calculates in this order:

1. Dimension tagged as Account
2. Dimension tagged as Time
3. Other Dense dimension
4. Other Sparse dimensions 

Otherwise, Essbase calculates in this order:

1. Dense dimension
2. Sparse dimensions

Dense dimensions are the dimensions that define the internal structure of the data block. They should reside at the top of the outline. 

Aggregating Sparse dimensions are dimensions that will be calculated to create new parent values. These dimensions should reside directly below the last Dense dimension in the Outline.  

Attribute  dimensions,  which are not included in the database consolidation, do not effect consolidation order.