AGGRESSIVEBLKOPTIMIZATION

This Essbase configuration setting improves batch calculation time for block storage cubes.

When there are dense Dynamic Calc members in the outline, a batch calculation with formulas uses blocks that contain data cells for all dense Dynamic Calc members. Setting AGGRESSIVEBLKOPTIMIZATION to TRUE, which should be done only if stored members are not dependent on any dense Dynamic Calc members, makes batch calculation work on kernel blocks (smaller blocks) directly, which may improve performance. Do not use this configuration setting if stored members are dependent on dense Dynamic Calc members.

Use this setting only if there is no formula dependency on dense Dynamic Calc members; otherwise, the calculation may produce incorrect results.

This setting does not apply to aggregate storage cubes.

Syntax

AGGRESSIVEBLKOPTIMIZATION TRUE | FALSE

• TRUE—Essbase uses batch calculation on smaller kernel blocks. Use only if stored members are not dependent on any dense Dynamic Calc members.

• FALSE—Essbase does not use batch calculation on smaller kernel blocks. The default value is FALSE.

Example

AGGRESSIVEBLKOPTIMIZATION TRUE

Improves calculation performance for outlines in which there is no formula dependency on dense Dynamic Calc members.