Working with Hybrid Aggregation in Essbase

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

Note:

For more information on hybrid aggregation in Essbase, see the Technical Reference for Oracle Analytics Cloud - Essbase guide.

Calculation Commands Not Supported for Hybrid Aggregation

The following calculation commands are not supported for hybrid aggregation mode. If encountered, Essbase defaults to block storage execution for these calculation commands.

  • CALC ALL

  • CCONV

  • CLEARCCTRACK

  • SET CACHE

  • SET CCTRACKCALC

  • SET CLEARUPDATESTATUS

  • SET DATAIMPORTIGNORETIMESTAMP

  • SET LOCKBLOCK

  • SET NOTICE

  • SET REMOTECALC

  • SET RUNTIMESUBVARS

  • SET UPTOLOCAL

Functions Not Supported for Hybrid Aggregation

The following functions are not supported for hybrid aggregation mode. If encountered, Essbase defaults to block storage execution for these functions.

  • @ALLOCATE

  • @CREATEBLOCK

  • @IRREX

  • @MDALLOCATE

  • @MDSHIFT

  • @MOVSUMX

  • @PTD

  • @SANCESTVAL

  • @STDEV

  • @STDEVP

  • @STDEVRANGE

  • @SYD

  • @TREND

  • @XWRITE