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, 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.
CALCREUSEDYNCALCBLOCKS TRUE CALCREUSEDYNCALCBLOCKS FALSE
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |