1. Database Administrator's Guide for Oracle Essbase
  2. Intelligent Calculation for Block Storage Cubes
  3. Intelligent Calculation and Data Block Status
  4. Marking Blocks as Dirty

Marking Blocks as Dirty

Essbase marks a data block as dirty in these situations:

  • Calculating the data block for a partial calculation of the database only if SET CLEARUPDATESTATUS AFTER is not part of the partial calculation statement in the calculation script

  • Loading data into the data block

  • Restructuring the database (for example, by adding a member to a dense dimension)

  • Copying data to the data block; for example, using DATACOPY