The SET CLEARUPDATESTATUS Command
When a BSO calc script calculates only partially, Essbase does not mark the calculated blocks as clean under Intelligent Calculation, unless you call SET CLEARUPDATESTATUS in the calc script. Learn how the command works and which parameter to use.
Only calculated data blocks are marked as clean. But in some cases, Essbase does not mark calculated blocks as clean; for example, if you calculate a subset of a database, or calculate a database in two passes. To manually mark data blocks as clean, use the SET CLEARUPDATESTATUS command in the calculation script.
To avoid unnecessary recalculations, select the appropriate parameter to use with SET CLEARUPDATESTATUS, based on your database:
-
SET CLEARUPDATESTATUS AFTER tells Essbase to mark calculated data blocks as clean, even for a partial calculation.
-
SET CLEARUPDATESTATUS ONLY tells Essbase to mark the blocks as clean without calculating them.
-
SET CLEARUPDATESTATUS OFF tells Essbase to calculate the blocks, but not mark them as clean, even on a full calculation (CALC ALL). The existing clean or dirty status of the calculated blocks will be unchanged.