Forcing a Bottom-Up Calculation

If it is appropriate for the site, you can force a bottom-up calculation on a top-down formula.

  To force a bottom-up calculation, use a tool:

Method

Topic Where Discussed

Location

Calculation function

@CALCMODE in a formula

Oracle Essbase Technical Reference

Calculation script command

SET FRMLBOTTOMUP

Oracle Essbase Technical Reference

essbase.cfg file setting

CALCOPTFRMLBOTTOMUP

or

CALCMODE

Oracle Essbase Technical Reference

Forcing a bottom-up calculation on a formula usually increases performance time. If the formula contains complex functions (for example, range functions) or if the formula's dependencies are not straightforward, a bottom-up calculation may produce results different from those of a top-down calculation.

Caution!

Before changing the setting CALCOPTFRMLBOTTOMUP or using the calculation script command SET FRMLBOTTOMUP in a production environment, check the validity of calculation results by comparing, relative to the same data, the results of a bottom-up calculation and the results of a top-down calculation.