12 Adopt Hybrid Mode for Fast Analytic Processing
The Oracle Essbase calculation and query processor enables you to perform real-time analytics using procedural calculations and read-and-write modeling capabilities.
If you have worked with Essbase 11g on-premises, then you likely are familiar with one or more of these cube design modes, tailored for different purposes:
- Block storage: best used when there are large, sparse dimensions. Cubes in this mode are stored and pre-aggregated to achieve good query performance. Includes a rich set of calculation functions for analysis.
- Aggregate storage: best used for cubes having a large number of dimensions, and many upper-level aggregations.
- Hybrid mode: block storage mode enhanced with the benefits of aggregate storage.
Hybrid mode is the default query engine for aggregating block storage cubes in Essbase 19c and Oracle Analytics Cloud - Essbase. Hybrid mode provides robust dependency analysis and fast aggregation. It is excellent at handling the complexity of stored-member dependencies on dynamic members.
In your analytic applications, Oracle recommends the use of dynamic dependencies, including sparse aggregations; you are not limited to implementing dynamic calc selectively on sparse dimensions, as was the case in Essbase 11g on-premises. In particular, sparse dynamic aggregations are possible and recommended, subject to performance tuning guidelines and testing.
Though hybrid mode is the default for aggregating block storage cubes in in Essbase 19c and Oracle Analytics Cloud - Essbase, it is not the default engine for executing calculation scripts. If your calculation scripts contain many sparse dependencies, Oracle recommends you enable hybrid mode for calculation scripts as well. The way to do this is to turn on the HYBRIDBSOINCALCSCRIPT configuration setting in your application configuration properties (or use the SET HYBRIDBSOINCALCSCRIPT calculation command to control it on a per-calculation basis).
Most Essbase calculation functions will operate in hybrid mode. To see a list and syntax for all hybrid mode supported calculation functions, as well as the few exceptions, see Functions Supported in Hybrid Mode. Parallel calculation using FIXPARALLEL is supported in hybrid mode, but not parallel calculation using CALCPARALLEL.
See ASODYNAMICAGGINBSO for the syntax to configure hybrid mode beyond the default settings, or to turn it off.
Topics in this section: