HYBRIDOPTIMIZEDSOLVEORDER

The HYBRIDOPTIMIZEDSOLVEORDER configuration setting for Essbase enables you to optimize the performance of aggregations and formulas when dimensions have the same default solve order.

HYBRIDOPTIMIZEDSOLVEORDER configuration is applicable to aggregate storage (ASO) and block storage (BSO) cubes.

Syntax

HYBRIDOPTIMIZEDSOLVEORDER TRUE | FALSE

TRUE—Aggregation / consolidation occurs prior to member formula evaluation, when default dimensional solve order is tied.
FALSE—Member formula evaluation occurs prior to aggregation / consolidation, when default dimensional solve order is tied. This is the default behavior.

Description

If HYBRIDOPTIMIZEDSOLVEORDER is TRUE, member formulas in dimensions with the same default solve order are evaluated after aggregations (ASO) or consolidations (BSO), regardless of the dimensions’ position in the outline order.

This configuration is useful for preventing implicit aggregations from overwriting formula calculations, in cases where member formulas are applied in the first few dimensions in the outline.

Notes

Custom solve order takes precedence over HYBRIDOPTIMIZEDSOLVEORDER setting.
HYBRIDOPTIMIZEDSOLVEORDER has no effect on aggregations that have dynamic children with formulas. These aggregations will be evaluated after their children formulas are executed.

Example

HYBRIDOPTIMIZEDSOLVEORDER TRUE