When you perform full database calculations, Essbase identifies which data blocks are calculated. Assume that you perform a full calculation and then load a subset of data. On subsequent calculations, you can choose to calculate only the data blocks that need calculation and the blocks that are not yet calculated. In Essbase, this process is called Intelligent Calculation.
Note: | Intelligent Calculation does not apply to aggregate storage databases. |
By default, Intelligent Calculation is turned on. You can change the default by using the UPDATECALC setting in the essbase.cfg file, and you can turn Intelligent Calculation on or off within calculation scripts.
“Optimizing with Intelligent Calculation” in the Oracle Essbase Database Administrator's Guide