Performing a Simulated Calculation

Before you can estimate calculation time, you must perform a simulated calculation on a data model that is based on your actual database.

  To perform a simulated calculation:

  1. Create a data model that uses all dimensions and all levels of detail about which you want information.

  2. Load all data. This procedure calculates only data loaded in the database.

  3. Create a calculation script with these entries:

    SET MSG ONLY;
    SET NOTICE HIGH;
    CALC ALL;

    If you are using dynamic calculations on dense dimensions, substitute the CALC ALL command with the specific dimensions that you need to calculate; for example, CALC DIM EAST.

    Note:

    If you try to validate the script, Essbase reports an error. Disregard the error.

  4. Run the script.

  5. Find the first sparse calculation message in the application log and note the time in the message.

  6. Note the time for each subsequent message.

  7. Calculate the dense dimensions of the model that are not being dynamically calculated:

    CALC DIM (DENSE_DIM1, DENSE_DIM2, …);
  8. Calculate the sparse dimensions of the model:

    CALC DIM (SPARSEDIM1, SPARSEDIM2, …);
  9. Project the intervals at which notices will occur, and then verify against sparse calculation results. You can then estimate calculation time.