CALCOPTFRMLBOTTOMUP

This configuration setting specifies whether Essbase optimizes the calculation of complex formulas on sparse dimensions in large cube 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 cubes.

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

This setting 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 the Designing and Maintaining Essbase Cubes.

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