CALCREUSEDYNCALCBLOCKS

Controls whether dynamically calculated values are re-used during retrievals.

This setting does not apply to aggregate storage databases.

Syntax

CALCREUSEDYNCALCBLOCKS TRUE | FALSE

TRUE Default value. Dynamically calculated values are re-used.
FALSE Dynamically calculated values are not re-used.

Description

By default, Analytic Services re-uses dynamically calculated values during retrievals. This can speed up retrievals that involve a large number of dynamically calculated blocks that are each required to compute several other blocks, such as when there is a large hierarchy of sparse dynamic calc members. However, a large dynamic calculator cache size or a large value for the CALCLOCKBLOCK may adversely affect the retrieval performance when this method is used. In such cases, CalcReuseDynCalcBlocks should be set to FALSE.

Example

CALCREUSEDYNCALCBLOCKS TRUE
CALCREUSEDYNCALCBLOCKS FALSE

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