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

Syntax

CALCREUSEDYNCALCBLOCKS TRUE | FALSE

• TRUE—Dynamically calculated values are re-used. This is the default.

• FALSE—Dynamically calculated values are not re-used.

Description

By default, Essbase 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