In this example, these conditions are true:
The setting for consolidating #MISSING values is turned off (the default).
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 68 shows a subset of the cells in a data block:
Table 68. Calculation Order Example 2: Input Cells and Calculated Cells
Year-Market | New York | Massachusetts | East |
---|---|---|---|
Jan | 112345 | 68754 | 4 |
Feb | 135788 | 75643 | 5 |
Mar | 112234 | 93456 | 6 |
Qtr1 | 1 | 2 | 3/7 |
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 Qtr1 cells for New York, Massachusetts, and East and the East cells for Jan, Feb, and March. In Table 68, the calculation order for these cells is represented by the numbers 1 through 7 that appear in the cells:
Qtr1 -> East is calculated on both the Year and Market consolidation paths. First, Qtr1 -> East is calculated as a consolidation of Qtr1 -> New York and Qtr1 -> Massachusetts. Second, Qtr1 -> East is calculated as a consolidation of Jan -> East, Feb -> East, and Mar -> East.
The results, as shown in Table 69, are identical to the results for example 1 (see Table 67, Calculation Order Example 1: Results). However, Qtr1 -> East has been calculated twice. This fact is significant when you need to load data at parent levels (see Cell Calculation Order: Example 3).
Table 69. Calculation Order Example 2: 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, its result is overwritten when Essbase consolidates Qtr1 -> East on the Market consolidation path. If you place a member formula on East in the database outline, the result is retained, because the Market consolidation path is calculated last.