Cell Calculation Order: Example 4

In this example, these conditions are true:

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.

Figure 124. Profit Branch of the Measures Dimension

This image shows the Profit branch of the Measures dimension.

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/YearJanFebMarQtr1
Sales31538320693221313
COGS14160143071441014
Margin14710/15
Marketing#MISSING#MISSING#MISSING15839
Payroll#MISSING#MISSING#MISSING12168
Misc#MISSING#MISSING#MISSING233
Total Expenses25811/16
Profit36912/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/YearJanFebMarQtr1
Sales31538320693221395820
COGS14160143071441042877
Margin17378177621780352943
Marketing#MISSING#MISSING#MISSING15839
Payroll#MISSING#MISSING#MISSING12168
Misc#MISSING#MISSING#MISSING233
Total Expenses   28240
Profit17378177621780312/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.