In this example, these conditions are true:
The Measures dimension is tagged as accounts.
Essbase calculates a dimension tagged as accounts first, followed by a dimension tagged as time. Therefore, in this example, Measures is calculated before Year.
The setting for consolidating #MISSING values is turned off (the default).
The Marketing, Payroll, and Misc Expenses values have been loaded at the Qtr1, parent level.
Figure 124, Profit Branch of the Measures Dimension shows the Profit branch of the Measures dimension in the Sample.Basic database. This example assumes that Total Expenses is not a Dynamic Calc member.
Table 72 shows a subset of the cells in a data block:
Table 72. Calculation Order Example 4: Input Cells, #MISSING Values, and Calculated Cells
Measures/Year | Jan | Feb | Mar | Qtr1 |
---|---|---|---|---|
Sales | 31538 | 32069 | 32213 | 13 |
COGS | 14160 | 14307 | 14410 | 14 |
Margin | 1 | 4 | 7 | 10/15 |
Marketing | #MISSING | #MISSING | #MISSING | 15839 |
Payroll | #MISSING | #MISSING | #MISSING | 12168 |
Misc | #MISSING | #MISSING | #MISSING | 233 |
Total Expenses | 2 | 5 | 8 | 11/16 |
Profit | 3 | 6 | 9 | 12/17 |
The following cells have multiple consolidation paths:
Because the setting for consolidating #MISSING values is turned off, Essbase does not consolidate the #MISSING values. Thus, any data that is loaded at parent levels is not overwritten by the #MISSING values and Essbase calculates the cells with multiple consolidation paths twice.
The results are shown in Table 73:
Table 73. Calculation Order Example 4: Results
Measures/Year | Jan | Feb | Mar | Qtr1 |
---|---|---|---|---|
Sales | 31538 | 32069 | 32213 | 95820 |
COGS | 14160 | 14307 | 14410 | 42877 |
Margin | 17378 | 17762 | 17803 | 52943 |
Marketing | #MISSING | #MISSING | #MISSING | 15839 |
Payroll | #MISSING | #MISSING | #MISSING | 12168 |
Misc | #MISSING | #MISSING | #MISSING | 233 |
Total Expenses | 28240 | |||
Profit | 17378 | 17762 | 17803 | 12/17 |
Based on the calculation order, if you place a member formula on, for example, Margin in the database outline, its result is overwritten by the consolidation on Qtr1.