Calculation and Recalculation Monitoring

If you have configured an active KPI and you have modified or configured its formula, filter, or threshold, you perform a calculation procedure to display the corresponding data, in the Dashboard. You perform the calculation for the current period of each KPI within the selected Business Context. You can also perform a recalculation ( historical calculation) for each KPI within the selected Business Context from the selected date till the current date. You can schedule to run the calculations periodically.

You can monitor the calculation or recalculation history for each Business Context (universe), or you can view the Business Contexts that are currently being calculated or recalculated.

ClosedTo access:

In the Active KPI pane, click the Calculation options button, and select the Calculation monitoring option.

ClosedMonitor the calculation or recalculation status for a specific Business Context

  1. In the Active KPI pane, click the Calculation options button, and select the Calculation monitoring option.

  2. In the Calculation Monitoring Dialog Box, select Calculation status by Business Context.

  3. Select the relevant Business Context in the Business Context drop down list. The list displays all the Business Contexts.

    The dialog box displays the status of the calculation or recalculation, the date when the calculation or recalculation started, and the date when the calculation or recalculation ended.

ClosedMonitor the calculations or recalculations that are currently running

  1. In the Active KPI pane, click the Calculation options button, and select the Calculation monitoring option.

  2. In the Calculation Monitoring Dialog Box, select Calculations running now.

    The dialog box displays the Business Contexts for which the calculation or recalculation are currently running.

  3. Select the relevant Business Context.The Current calculation periods area displays the calculation periods (Yearly, Monthly, Quarterly, Weekly, or Daily) that are being used currently by the calculation or recalculation process. Click the Business Context to refresh the data about the calculation or recalculation currently running. The Calculation start time field displays the date and time when the calculation or recalculation started.

ClosedCalculation Monitoring Dialog Box

Use the dialog box to monitor the calculation or recalculation history for each Business Context, or to view the Business Contexts that are currently being calculated or recalculated.

User interface elements are described below (when relevant, unlabeled elements are shown in angle brackets):

UI Element

Description

Monitoring options

Select:

  • Calculation status by Business Context. To monitor the calculation or recalculation history of the selected Business Context. For details, see <Calculation status by Business Context>.
  • Calculations running now. To view the Business Contexts that are currently being calculated or recalculated. For details, see <Calculations running now>.
Business Context Select the Business  Context you want to monitor in the drop down list. The list displays all the Business Contexts.

Closed<Calculation status by Business Context>

User interface elements are described below (when relevant, unlabeled elements are shown in angle brackets):

UI Element

Description

Business Context Select the relevant Business Context in the drop down list. The list displays all the Business Contexts.
Status The status of the calculation or recalculation. It can be: Running Now, Not Calculated, Error, or Finished.
Start Date

The date and time when the calculation or recalculation started.

Note The start time is the start of the period of the calculation or recalculation.

End Date The date and time when the calculation or recalculation ended. When the calculation or recalculation is still running, the field is empty.
Last modified date The date and time when the last calculation was completed. If the calculation has completed the End Date and the Last modified date should be the same. If the calculation is still running, the database is updated all the time with the new calculation results and new periods that are currently calculated, and each time the database is updated with some new records related to the calculation, the last modified date will change. This information is useful for historical recalculations that may take a long time to run.

Closed<Calculations running now>

User interface elements are described below (when relevant, unlabeled elements are shown in angle brackets):

UI Element

Description

Business Context The list of the Business Contexts for which a calculation or recalculation is currently running. Click the relevant universe to display the calculation or recalculation details.
Current calculation periods

This area displays the calculation periods (Yearly, Monthly, Quarterly, Weekly, or Daily) that are being used currently by the calculation or recalculation process. The numbers in the boxes change when the period changes and you click the Business Context.

Calculation start time. The date and time when the calculation or recalculation started.