Consider this calculation required for Profit%:
Profit % = Profit % Sales
Assume that Table 186 shows a subset of a data block with Measures and Year as dense dimensions. Measures is tagged as accounts, and Year is tagged as time. The AGGMISSG configuration setting is turned off (the default).
Data values have been loaded into the input cells. Essbase calculates the cells in which the numbers 1 through 7 appear, in that order. For example, Profit % -> Jan is calculated first; Profit% -> Qtr1 has multiple consolidation paths.
For information on how cell calculation order depends on database configuration, see Cell Calculation Order. |
Essbase uses this calculation order:
Essbase calculates the formula Profit % Sales for Profit % -> Jan, Profit % -> Feb, Profit % -> Mar, and Profit % -> Qtr1 (1, 2, 3, 4 above).
Essbase calculates Profit -> Qtr1 and Sales -> Qtr1 by adding the values for Jan, Feb, and Mar (5, 6 above).
Essbase calculates Profit % -> Qtr1 by adding the values for Profit % -> Jan, Profit % -> Feb, and Profit % -> Mar (7 above). This addition of percentages produces the value 125%, which is not the correct result.
If you tag Profit% as two-pass in the database outline, Essbase uses the Profit % Sales formula to recalculate the Profit% values and produce the correct results.
For information about multiple calculation passes, see Calculation Passes.