Marking Blocks as Clean

Essbase marks data blocks as clean in these types of calculations:

• A full calculation (CALC ALL) of a database (the default calculation).

• A calculation script that calculates all the dimensions in one CALC DIM statement.

  For example, the following calculation script calculates all members in the Sample.Basic database:

  CALC DIM(Measures, Product, Market, Year, Scenario);

  Compare this calculation script to a calculation script that calculates all the members with two CALC DIM statements:

  CALC DIM(Measures, Product);
  CALC DIM(Market, Year, Scenario);

Using two CALC DIM statements causes Essbase to do at least two calculation passes through the database. In this calculation, Essbase does not, by default, mark the data blocks as clean. Because Intelligent Calculation depends on accurate clean and dirty status, you must manage these markers carefully. See Maintaining Clean and Dirty Status.

Essbase marks calculated data blocks as clean only in the situations described above, unless you use the SET CLEARUPDATESTATUS command in a calculation script. See Using the SET CLEARUPDATESTATUS Command.