1. Database Administrator's Guide for Oracle Essbase
  2. Intelligent Calculation for Block Storage Cubes
  3. Considerations for Essbase Intelligent Calculation on Oracle Exalytics In-Memory Machine

Considerations for Essbase Intelligent Calculation on Oracle Exalytics In-Memory Machine

The following functionality applies only to Essbase running on an Oracle Exalytics In-Memory machine.

Status bits for Intelligent Calculation on a block storage database are not persisted. Therefore, Intelligent Calculation works as intended only if both of the following conditions are true:

  • The whole index fits in the index cache

  • Related calculation scripts that use Intelligent Calculation complete within the lifetime of the Essbase Server

For Intelligent Calculation, set the index cache size large enough to fit the whole index and to account for future index growth due to data load or calculation.