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.