Calculation Tasks Management

In Hyper Historian, calculated tags are calculated in accordance with their triggers on an ongoing basis. There may be a time at which you will want to recalculate the calculated tags that are already stored in Hyper Historian, for example after new historical data is added or historical data has been updated. You can recalculate calculated tags by using the Calculation Tasks Management form (shown below), available in Hyper Historian under the System Administration node. You can schedule a task to run at a specific time in the future, or you can run it immediately.

Note.  Tasks are stored in a text file that you can update manually or by using an automated process; you are not required to use the Hyper Historian form provided for you in the GENESIS64 Workbench. For more information, refer to the Calculation Tasks File section at the end of this topic.

To Set Up a Task for Recalculating Historical Calculated Tags:

  1. Start the Workbench, then expand your project. Next, expand the Historical Data node to show the Hyper Historian node. Expand the Hyper Historian node to show the System Administration node.

  2. Expand the System Administration node in the navigation tree and right-click on the Calculation Tasks Management node, as shown below, then click on Edit or Edit on a new tab.

Editing Calculation Tasks Management from Project Explorer

-OR-

Select Calculations Tasks Management, then click on the Edit button, shown below, in the Edit section of the Home ribbon in the Workbench.

Edit Button

  1. This opens the Calculation Tasks Management properties window, shown below, beneath the Project Details section in the Workbench. Enter a name in the Hyper Historian Calculation Tasks Storage Management Name text entry field.

Calculation Tasks Management Properties

  1. To enable periodically polling the status of task processing, put a checkmark in the Enabled checkbox. This allows the Processing Task bar to show you the current status of storage processing. If the Enabled checkbox is empty, the Processing Task status does not provide a monitor for task processing.

  2. To add a task for recalculating calculated tags, click the Add Task button []. This opens the Add Calculation Task dialog box.   

  3. If you want timestamps to be in the client's local time, leave the check mark in the Times Are In Local Time check box. To use UTC times for the timestamps, remove the check mark from the box.

  4. In the Execution Time box, schedule a time for the recalculation to run.

  • To start the recalculation now (that is, as soon as you click the Okay button), put a check mark in the Now check box.

  • Alternatively, to execute the task at a specific date and time, leave the Now check box unchecked and enter the Date, Hour, Minute, and Second in the Execution Time box instead.  

  1. Next, in the Calculation Interval box, specify the historical time range for which calculated tags are to be recalculated.
    • To recalculate all calculated tag data stored in the Hyper Historian database, leave the Start Time and End Time check boxes empty. Be aware that doing this may take a significant amount of time and computer resources.
    • Alternatively, you can limit the time frame in which recalculations are performed. For example, you can check both Start and End Times and specify a limited time range so that only the calculated tag values that were stored during the specified time range are recalculated.
    • You can enter a Start Time and leave the End Time empty so that all values stored after the Start Time are recalculated; or conversely you can leave the Start Time empty and specify an End Time so that all values that were stored up until the End Time are recalculated.
  1. To stop the Performance Calculation Engine from doing routine calculations based on calculated tags' triggers while the recalculation occurs, put a check mark in the Exclusive Calculation check box. How you use this check box is determined by the volume of data to be recalculated and how quickly you want the recalculation to be done, and whether you able to temporarily stop ongoing calculations. If you put a check mark in this box, when the recalculations are done, ongoing calculations of calculated tags will automatically resume.
  2. You can specify the tags to be recalculated by putting a check mark in the Use Tag Filter check box and entering a specific tag, or part of a tag using wild card characters that identify the tags to recalculate.
  3. When you are done, click OK to close the dialog box and add the task to the Storage Management form.
  4. To add another task, repeat steps 3 through 9.
  5. To be able to monitor the progress of recalculation tasks and to be able to see which task is being processed, verify that the Enabled check box has a check mark in it. If the Enabled check box is empty, processing will still occur, but you will not be able to monitor it in the Processing Task bar at the top of the Calculation Tasks Management window.
  6. At this point you might notice the "plus sign" that appears in the left-most column. This icon identifies the new tasks that have not yet been saved. You can also edit and remove tasks by selecting the task and clicking the Edit Task[] buttons. Selected tasks marked as new can be edited. Once they are committed to runtime, they can only be removed. When you edit or remove a task, the icon in the left-most column changes. Any task that has been identified for removal has a large X in the left-most column, meaning that you can still cancel its removal by clicking the Cancel Remove [] button. Once you click the Apply button, though, all of your changes will be saved and the icons in the left-most column will disappear along with any tasks you marked for removal.
  7. When you are done, click Apply to save the tasks.

When a task runs, a progress meter appears in the Storage Monitoring section at the top of the window, and a timer shows how long the task has been running.

The Last Modification Time field at the top of the window displays the last time the task list was changed.

Calculation Tasks File

Tasks are stored in a text file that you can update manually or by using an automated process. You can use this file to schedule recalculation tasks instead of Hyper Historian's Calculation Tasks Management form in the GENESIS64 Workbench.

The Calculation Tasks file's default location is:

system:\ProgramData\ICONICS\HyperHistorian\Logger\CalculationTasks

This file is a text file with an INI file like structure, in that it contains a set of keyword=Value; sections.

Valid keywords for sections in the file are:

  • Begin=DateTime - Begin recalculation time
  • End=DateTime - End recalculation time
  • Exclusive=boolean - TRUE stops on-line calculations when the recalculation task has been processed
  • TagFilter="string"

The following is an example of recalculation task structure:

Begin=20110623T04-00-00;End=20110624T04-00-00;Exclusive=True;TagFilter="";

For additional descriptions of these values, refer to the discussions at the top of this topic.

See Also:

Welcome to Hyper Historian

Aggregate Tasks Management

Synchronization Tasks Management

Archiving Management