In this example, which is the simplest case, these conditions are true:
Market and Year are dense dimensions.
Essbase calculates dense dimensions in the order in which they are defined in the database outline. Assume that the Year dimension is positioned in the database outline before the Market dimension and is calculated first.
Table 66 shows a subset of the cells in a data block:
Table 66. Calculation Order Example 1: Input Cells and Calculated Cells
Year-Market | New York | Massachusetts | East |
---|---|---|---|
Jan | 112345 | 68754 | 3 |
Feb | 135788 | 75643 | 4 |
Mar | 112234 | 93456 | 5 |
Qtr1 | 1 | 2 | 6 |
Data values have been loaded into the following input cells:
Jan -> New York
Feb -> New York
Mar -> New York
Jan -> Massachusetts
Feb -> Massachusetts
Mar -> Massachusetts
Essbase calculates the following cells. In Table 66, the calculation order for these cells is represented by the numbers 1 through 6 that appear in the cells:
Qtr1 -> East has multiple consolidation paths; it can be consolidated on Market or on Year. When consolidated on Market, it is a consolidation of Qtr1 -> New York and Qtr1 -> Massachusetts. When consolidated on Year, it is a consolidation of Jan -> East, Feb -> East, and Mar -> East.
Essbase knows that Qtr1 -> East has multiple consolidation paths. Therefore, it calculates Qtr1 -> East only once by consolidating the values for Qtr1 and uses the consolidation path of the dimension calculated last (in this example, the Market dimension), as shown in Table 67.
Table 67. Calculation Order Example 1: Results
Year-Market | New York | Massachusetts | East |
---|---|---|---|
Jan | 112345 | 68754 | 181099 |
Feb | 135788 | 75643 | 211431 |
Mar | 112234 | 93456 | 205690 |
Qtr1 | 360367 | 237853 | 598220 |
Based on the calculation order, if you place a member formula on Qtr1 in the database outline, Essbase ignores it when calculating Qtr1 -> East. If you place a member formula on East in the database outline, the formula is calculated when Essbase consolidates Qtr1 -> East on the Market consolidation path.
If required, you can use a calculation script to calculate the dimensions in the order you choose. See Developing Calculation Scripts for Block Storage Databases.