CALCOPTFRMLBOTTOMUP

Specifies whether Analytic Services optimizes the calculation of complex formulas on sparse dimensions in large database outlines. If enabled, this setting tells Analytic Services to perform a bottom-up calculation on formulas that would otherwise require a top-down calculation.

This setting does not apply to aggregate storage databases.

Syntax

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.

Description

This setting tells Analytic Services 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.

Notes

Example

CALCOPTFRMLBOTTOMUP TRUE

See Also

SET FRMLBOTTOMUP (calculation command)
SET CREATENONMISSINGBLK (calculation command)

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com