...
Configuration dialog box of processes consists of several parts (tabs) containing the similar parameters.
General properties
Groups
Archive
Statement
Time parameters
Conditions
Statistics
Filter
Kotva | ||||
---|---|---|---|---|
|
...
There are the following options:
- Archive object values - allows to archive values of D2000 system objects. Archiving can be either periodical or on value change.
- Ignore identical - optimization for processing of old values.
- Calculate archived values by statistical function - allows to calculate values of defined object of Historical value by a statistical function.
- Calculate archived values by defined statement - calculates defined object of Historical value type that are defined in the tab Statement. Calculation gives values, that are to be archived.
- Fill archive from script (Value storage) - values can be filled either from an ESL script or manually from the process D2000 HI.
...
Optimisation of old values processing coming from communication (automatically or as a result of TELL command GETOLDVAL) or values of remote tags (as a result of TELL command GETOLDVAL).
If the checkbox is checked, during processing of old value the archive database is queried whether the value is already present there. If it exists, the value is discarded (and recalcs of statistical or calculated archived values which use this primary archive value are not performed either).
Note: Optimisation is useful e.g. for archiving of I/O tags from communication using the protocol IEC62056-21:2002 File I/O. Its communication files contain several historical values (which KOM process sends as old values) and one new value for every I/O tag.
...
- Periodical - writing values into the archive is periodical. The archiving process in defined time moments stores the archive object value into the archive. Timestamp (the value time) is not given by the occurrence time of the archive object value, but by the time of the value storing into the archive.
Reading the values stored periodically by means of D2000 system (ESL: GETARCHARR, GETARCHVAL, D2000 ObjApi: GetArchivData, D2000 VBApi: VBApiGetArchData, D2000 WorkBook) follows the rule that the archive object value out of time moments given by the period, is unknown (invalid). The result of the data reading is therefore given by the oversampling and the begin (BT) and end (ET) time as follows:- oversampling (step) = 0
The reading results are all the values, time of which belong into the interval <BT, ET>. - oversampling (step) <> 0
The reading result is the value array with timestamps continuously:
BT+0*step, BT+1*step, BT+2*step, ..., BT+N*step.
The number of values is given by the end ET of the time interval. The array value without a record with the same timestamps in the archive is invalid. The value with such a record is filled according to it. The above facts imply, that when reading periodical data, it is necessary (advisable):- to adjust BT exactly for some of the object archiving moments given by the period and time offset of the archiving.
- oversampling value (step) must be an integer multiple of the archiving period.
- ET = BT + (N-1)*step, where N is an integer number: the number of values in the final selection.
Note: The statistical archive, from the reading point of view, acts periodically.
- oversampling (step) = 0
On value change - just value changes of the archive object undetected by the value filter are stored into the archive.Kotva sa_filter1 sa_filter1
Reading of values stored by using a filter by means of D2000 system (ESL: GETARCHARR, GETARCHVAL, D2000 ObjApi: GetArchivData, D2000 VBApi: VBApiGetArchData, D2000 WorkBook) follows the rule that the archive object value at any time (t) is given (equal) by the last historical value before the given time (t). The data reading result is therefore given by the oversampling and the begin (BT) and end (ET) time as follows:- oversampling (step) = 0
The reading result are all the values, time of which belongs to the interval <BT, ET> and 1 value before BT time, in case there is no value exactly equal with BT time in the archive. - oversampling (step) <> 0
The reading result is a array of values with timestamps continuously:
BT+0*step, BT+1*step, BT+2*step, ..., BT+N*step.
The number of values is given by the end ET of the time interval. The array value without any record in the archive with the same timestamp will be given by the last value before the time required.
- oversampling (step) = 0
...
Note: To ensure the correct functionality of the feature Publish values for an one-column historical value (structured historical value) the number of rows (columns) of the structured variable defined in the parameter Target object must be the same as the number of rows (columns) of the object defined by the parameter Object to archive.
Target object
The input field is enabled if the option Publish values is checked. It allows you to define an object, that will contains values of the historical value. When archiving a simple historical value, target object must not be defined, but must be defined for one-column historical value and structured historical value - the size of target object must be the same as the size of the object defined by the parameter Object to archive.
Kotvaprepocet_stat_funkciou prepocet_stat_funkciou
CALCULATE ARCHIVED VALUES BY STATISTICAL FUNCTION
prepocet_stat_funkciou | |
prepocet_stat_funkciou |
...
If the option Publish values is checked, then the historical value publishes its last archived value in the way, that depends on the object defined by the parameter Historical value as follows:
- For a simple HV - the object of Historical value type you are configuring gets the last value (if the parameter Historical value is not defined).
- When archiving an one-column HV - last archived values of individual items are filled into the relevant items of the column of a Structured variable type object defined by the parameter Target object.
- When archiving a structured HV - last archived values of individual items are filled into the relevant items of a Structured variable type object defined by the parameter Target object.
Note: To ensure the correct functionality of the feature Publish values for an one-column HV (structured HV) the number of rows (columns) of the structured variable defined in the parameter Target object must be the same as the number of rows (columns) of the object defined by the parameter Historical value.
Target object
The input field is enabled if the option Publish values is checked. It allows you to define an object, that will contains values of the historical value. When archiving a simple HV, target object may not be defined, but must be defined for one-column HV and structured HV (see the parameter Historical value) - the size of target object must be the same as the size of the object defined by the parameter Historical value.
Kotvaprepocet_zad_vyrazom prepocet_zad_vyrazom
CALCULATE ARCHIVED VALUES BY DEFINED STATEMENT
prepocet_zad_vyrazom | |
prepocet_zad_vyrazom |
The option allows to define a mathematic expression among objects of Historical value type (the tab Statement). The expression can not contain the references to any current values of D2000 system objects. Calculation of the expression provides values to be archived.
For example:
We have got two measurement points - two I/O tags which are archived as the historical values H.Flow1 and H.Flow2. You need to archive the sum of both the flows. You can use two methods:
...
Definition of archive size - see the parameter Publish values. The parameter will appear, if the parameter Publish values is not checked.
...
Definition of an object, that will contain values of the historical value - see the parameter Publish values. The parameter will appear, if the option Publish values is checked.
...
If the option is checked, you must define a period and offset (the tab Time parameters).
Kotva | ||||
---|---|---|---|---|
|
...
The parameter will appears if the parameter Publish values is checked. Allows to define an object, that will contains values of the historical value - see the parameter Publish values. If it is not defined, the historical value itself will contain the values.
...
For periodical data archiving, it is defined, what time data with the value for the given period will be stored into the archive. The time data can present the begin time - Period begin option or the end time of the interval (period) - Period end option.
Note: For archives filled from script, this setting does not affect anything - the data has a time stamp with which it was stored from the script.
Kotva | ||||
---|---|---|---|---|
|
...