Specifies whether Essbase optimizes the calculation of complex formulas on sparse dimensions in large database outlines. If enabled, Essbase performs a bottom-up calculation on formulas that would otherwise require a top-down calculation.
This setting does not apply to aggregate storage databases.
CALCOPTFRMLBOTTOMUP TRUE | FALSE
TRUE—Optimizes the calculation of formulas on sparse dimensions in large database outlines by forcing a bottom-up calculation.
FALSE—Does not force a bottom-up calculation for formulas on sparse dimensions in large database outlines. The default is FALSE.
This setting tells Essbase whether to optimize the calculation of formulas on sparse dimensions in large database outlines, so that you can efficiently use CALC ALL and CALC DIM commands to calculate the database.
You can override the CALCOPTFRMLBOTTOMUP essbase.cfg setting by using the SET FRMLBOTTOMUP command in a calculation script.
For information on complex formulas and top-down calculations, see the Oracle Essbase Database Administrator's Guide.
Forcing a bottom-up calculation on a formula may produce results that are inconsistent with a top-down calculation if:
The formula contains complex functions (for example, range functions)
The formula's dependencies are not straightforward
Before using the CALCOPTFRMLBOTTOMUP setting in a production environment, be sure to check the validity of calculation results produced when the setting is enabled (set to TRUE).
The SET CREATENONMISSINGBLK calculation command can force top-down calculations, regardless of the value of the CALCOPTFRMLBOTTOMUP setting.
CALCOPTFRMLBOTTOMUP TRUE
SET FRMLBOTTOMUP (calculation command)
SET CREATENONMISSINGBLK (calculation command)