Controls whether dynamically calculated values are re-used during retrievals.
This setting does not apply to aggregate storage databases.
CALCREUSEDYNCALCBLOCKS TRUE | FALSE
TRUE—Default value. Dynamically calculated values are re-used.
FALSE—Dynamically calculated values are not re-used.
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.
CALCREUSEDYNCALCBLOCKS TRUE CALCREUSEDYNCALCBLOCKS FALSE