SET UPDATECALC

SET UPDATECALC

This is a calculation command which turns on/off the intelligence calculation.

What is intelligence calculation ?

Analytic Services Calculates the dirty cells for getting correct results on dependent parents is nothing but intelligence calculation.

Or

Essbase calculates only data that changed since the prior calculation.

Or

Essbase will only have to calculate the data blocks that have been modified and their dependent parents (i.e. subtotals above them they are impacted by the data update).  .

Or

Analytic Services calculates only dirty blocks, such as updated data blocks and their dependent parents. Therefore, the calculation is very efficient.

SYNTAX:

SET UPDATECALC ON | OFF;

ON	Analytic Services calculates only blocks marked as dirty. Dirty blocks include updated blocks and their dependent parents. The default setting is ON.
OFF	Analytic Services calculates all data blocks, regardless of whether they have been updated.

Note : You can change this default using the UPDATECALC TRUE | FALSE setting in the essbase.cfg file.