CALCOPTFRMLBOTTOMUP configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

Syntax

CALCOPTFRMLBOTTOMUP TRUE | FALSE

• TRUE—Optimizes the calculation of formulas on sparse dimensions in large outlines by forcing a bottom-up calculation.

• FALSE—Does not force a bottom-up calculation for formulas on sparse dimensions in large outlines. This is the default.

Description

CALCOPTFRMLBOTTOMUP tells Essbase whether to optimize the calculation of formulas on sparse dimensions in large cube outlines, so that you can efficiently use CALC ALL and CALC DIM commands to calculate the cube.

You can override the CALCOPTFRMLBOTTOMUP setting by using the SET FRMLBOTTOMUP command in a calculation script.

Notes

• For information on complex formulas and top-down calculations, see Bottom-Up and Top-Down Calculation.

• 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.

Example

CALCOPTFRMLBOTTOMUP TRUE

See Also

SET FRMLBOTTOMUP (calculation command)

SET CREATENONMISSINGBLK (calculation command)