Benefits of Hybrid Mode

Hybrid mode combines block storage procedural calculation and write back functionality with aggregate storage aggregation performance. Hybrid mode offers the benefit of fast performance by eliminating the need to store sparse aggregations. This, in turn, reduces database size and memory footprint, and speeds up batch calculation times. The deployment considerations are simplified, as you no longer have to consider using block storage for heavy use of level 0 calculations, versus aggregate storage for many upper-level aggregations, versus designing partitioned models in which the cube is split along dimensional lines to facilitate calculation performance.

The following are some scenarios where hybrid mode is likely to improve calculation performance:

• A block storage database has sparse members that are not level 0, and are calculated according to hierarchy (rather than by calculation scripts).

• A sparse, dynamic calc parent member has more than 100 children.

• You are using a transparent partition between an empty aggregate storage target and a block storage source. If the formulas on the aggregate storage target are simple and translatable to block storage formula language, you can achieve fast results on block storage using hybrid mode.

• You are using a transparent partition between two block storage databases, and calculation performance is a concern.

Another benefit of hybrid mode is that it enables you to use scenario management.