Essbase calculates a database at the data block level, bringing one or more blocks into memory and calculating the required values within the block. Essbase calculates the blocks in order, according to their block numbers. The database outline tells Essbase how to order the blocks. Within each block, Essbase calculates the values in order according to the hierarchy in the database outline. Therefore, overall, Essbase calculates a database based on the database outline.
When you perform a default calculation (CALC ALL) on a database, Essbase calculates the dimensions in this order:
If both a dimension tagged as accounts and a dimension tagged as time exist, and if formulas are applied to members on the accounts dimension, Essbase calculates in this order:
Otherwise, Essbase calculates in this order:
Dense dimensions (in the order in which they are displayed in the database outline)
Sparse dimensions (in the order in which they are displayed in the database outline)
Attribute dimensions, which are not included in the database consolidation, do not affect calculation order. See Working with Attributes. |
In the Sample.Basic database, the dimensions are calculated in this order: Measures, Year, Scenario, Product, and Market.
You can override the default order by using a calculation script. See Developing Calculation Scripts for Block Storage Databases.