Intelligent Calculation with a Small Index

  To use Intelligent Calculation when the index is small:

  1. Create a calculation script to calculate the database, but tell Essbase not to mark the calculated data blocks as clean.

  2. Mark all data blocks as clean and do not recalculate the data blocks.

    SET CLEARUPDATESTATUS OFF;
    CALC ALL;
    CALC TWOPASS;
    SET CLEARUPDATESTATUS ONLY;
    CALC ALL;

    With the example script, Essbase performs these tasks:

  3. The SET CLEARUPDATESTATUS OFF command tells Essbase not to mark the calculated data blocks as clean.

  4. The first CALC ALL command causes Essbase to cycle through the database, calculating all dirty data blocks. Essbase does not mark the calculated data blocks as clean. Essbase does not automatically recalculate the formulas tagged as two-pass in the database outline.

  5. The CALC TWOPASS command causes Essbase to cycle through the database, recalculating the formulas that are tagged as two-pass in the dimension tagged as accounts in the database outline. Essbase recalculates the formulas because the required data blocks are not marked as clean by the previous CALC ALL. Essbase does not mark the recalculated data blocks as clean.

  6. The SET CLEARUPDATESTATUS ONLY command tells Essbase to mark the data blocks as clean but not to calculate the data blocks. This command disables calculation.

  7. The last CALC ALL command causes Essbase to cycle through the database and mark all the data blocks as clean. Essbase searches the index and marks the data blocks as clean. It does not calculate the data blocks.