1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Commands
  3. Calculation Command List
  4. SET HYBRIDBSOINCALCSCRIPT

SET HYBRIDBSOINCALCSCRIPT

The SET HYBRIDBSOINCALCSCRIPT calculation command controls whether the subsequent blocks in the current Essbase calculation script execute in hybrid mode. This command can be used to enable or disable hybrid mode for specific blocks in the script.

This setting applies only to block storage databases.

Hybrid aggregation for block storage databases means that wherever possible, block storage data calculation executes with efficiency similar to that of aggregate storage databases.

Syntax

SET HYBRIDBSOINCALCSCRIPT NONE|FULL;

Parameters

NONE

The calculation script runs in block storage mode. This is the default.

FULL

The calculation script runs in hybrid mode.

Notes

  • The calculation commands CALC DIM and AGG are not supported in hybrid mode.

  • Only formulas that have dynamic dependencies are supported in hybrid mode.

Example

SET HYBRIDBSOINCALCSCRIPT FULL;