1. Oracle Enterprise Performance Management Cloud Operations Guide
  2. Troubleshooting EPM Cloud Issues
  3. Troubleshooting Business Rules and Member Formula Errors and Performance
  4. Business Rule Optimization for Hybrid-Enabled Cubes

Business Rule Optimization for Hybrid-Enabled Cubes

A hybrid-enabled cube ensures that it is hybrid-enabled for queries (for retrievals, reports, and so on). By default, cubes are not hybrid-enabled for calculations because hybrid aggregation is not supported for some functions (including AGG, CALC DIM,and @MDALLOCATE). If your calculations involve formulas with dynamic dependency and are not using functions for which hybrid is not supported, turning on hybrid for such calculations may provide some performance benefit: you can turn on hybrid for calculations in a business rule as needed using the following directive:

SET HYBRIDBSOINCALCSCRIPT FULL; for detailed information on this command, see "SET HYBRIDBSOINCALCSCRIPT" in Calculation and Query Reference for Oracle Essbase.

Hybrid mode can be turned off using the SET HYBRIDBSOINCALCSCRIPT NONE; directive.

For a list of functions for which hybrid aggregation is supported, see Functions Supported in Hybrid Aggregation Mode in Technical Reference for Oracle Analytics Cloud - Essbase

As with all commands, these should be carefully tested to ensure that they give benefit. Note the following:

  1. Only formulas that have dynamic calc dependencies are supported in hybrid mode.
  2. DATAEXPORT for dynamic members does not use hybrid mode.
  3. Do not use CREATENONMISSINGBLOCK or CREATEBLOCKONEQ in calculation scripts you want to run in hybrid mode.