1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. CALCREUSEDYNCALCBLOCKS

CALCREUSEDYNCALCBLOCKS

This Essbase configuration setting controls whether dynamically calculated values are re-used during retrievals.

This setting does not apply to aggregate storage cubes.

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