SET FRMLBOTTOMUP

Optimizes the calculation of complex formulas on sparse dimensions in large database outlines. This command tells Analytic Services to perform a bottom-up calculation on formulas that would otherwise require a top-down calculation.

Syntax

SET FRMLBOTTOMUP ON|OFF;

ON Turns on the bottom-up sparse formula calculation method.
OFF Turns off the bottom-up sparse formula calculation method. The default setting is OFF. You can change this setting by using CALCOPTFRMLBOTTOMUP TRUE in the essbase.cfg file.

Description

The SET FRMLBOTTOMUP command optimizes the calculation of complex formulas on sparse dimensions in large database outlines. You might want to turn on this setting when using the CALC ALL; and CALC DIM; commands to calculate the database.

Notes

Example

SET FRMLBOTTOMUP ON;

See Also

CALCOPTFRMLBOTTOMUP (configuration file setting)
Set Commands

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