Historical values - configuration dialog box

Editing of all objects in the process D2000 CNF is being performed in the configuration dialog box, a specific part of which is common for all editable objects and another part depends on the type of edited object.

Configuration dialog box of processes consists of several parts (tabs) containing the similar parameters.

General properties
Groups
Archive
Statement
Time parameters
Conditions
Statistics
Filter

General properties


Description

A text string describing the historical value. Maximum: 128 characters.
Possibility to use the Dictionary (to open click the CTRL+L).

Status Text

Defines a status text of the historical value. The status text allows to redefine individual values' identification for the historical value.

Transformation palette

Selection of an index to transformation palette. See the topic Transformation palette.

Value type

Selection of a value type of the historical value. The possible types are shown in the following table.

LabelValue type
Int-IntegerInteger
Re-RealReal
Bo-BooleanBoolean

Note: Value type may be defined for the archive purpose Calculate archived values by defined statement only.

Technical units

Technical units of the historical value. Maximum: 12 symbols. Possibility to use the Dictionary (to open click the CTRL+L).

Limits

Technological limits are effective only for historical values which are calculated by D2000 Archiv (evaluated and statistical historical values). There are 4 limits defined: VHL, HL, LL and VLL. Limit can be defined either directly – by the value entry into the input field, or its value can be determined by a system object (dynamic limit) – the button right from the input field.

VHLVery High Limit - the highest limit
HLHigh Limit
LLLow Limit
VLLVery Low Limit - the lowest limit


Values of the individual limits determine the state of the historical value according to its value. The relation value- limits gives six possible states.

LimitObject state according to relation Value - Limit

Above VHL (object value > VHL)
VHL

Above HL (HL < object value < VHL)
HL

Normal (LL < object value < HL)
LL

Bellow LL (VLL < object value < LL)
VLL

Bellow VLL (object value < VLL)

As the limits can be dynamic (determined by the object value), a situation when the relation VLL<LL<HL<VHL is not valid (the limits crossing) can occur. The historical value is then in Limit Problem state.

Note: Changing the value of dynamic limit will not cause a new evaluation of limits and possibly a new value with a changed Limits attribute. New value value of dynamic limit is taken into account only when archiving a new value.

Archive


Archive purpose

There are the following options:

Archiving parameters

The part of the configuration dialog box contains the following options:

ARCHIVE OBJECT VALUES

Ignore identical

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.

Object to archive

Definition of a D2000 system object, values of which are to be archived. The object may be defined either by typing its name into the input edit field or selecting from the list of object. To open the list of object click the button right from the input field.

Object to archive or value source may be:

  1. An object, value of which is a simple type (Integer, Boolean, Real,...) - just one value is archived, therefore such archived object is called simple historical value.
  2. An item of object of Structured variable type - there is also just one value archived, therefore such archived object is called simple historical value, too.
  3. A column of object of Structured variable type (e.g. SV.Strct[0]^ColName) - there are archived all values of the column. Such archived object is called one-column historical value.
  4. An entire object of Structured variable type (e.g. SV.Struct) - there are archived all values of the object. Such archived object is called structured historical value.

Note: The above described fact implies, that the object to archive directly specifies the type of historical value - simple, one-column or structured historical one. So all changes in the configuration of the historical value has directly effect on its functionality, mainly if the object is used in other historical values.

Archiving method

When archiving the object values into the primary archive, it is possible to use the following method of archiving:

Publish values

If the option Publish values is checked, then the historical value publishes its last archived value in the way, that depends on the object to archive as follows:

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.

CALCULATE ARCHIVED VALUES BY STATISTICAL FUNCTION

Historical value

Definition of an object of Historical value type, values of which are to be calculated. It can be:

* The list of columns is given by the respective structure definition, that defines the structure of the historical value (e.g. H.Struct[2]^ColName).

Publish values

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:

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.


CALCULATE ARCHIVED VALUES BY DEFINED STATEMENT

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:

  1. Create an object of Eval tag type, that adds together the values of the I/O tags and then archive it.
  2. Create an object of Historical value type with the expression of „H.Flow1 + H.Flow2“.

Both the methods gives the same result. A problem may occur, when you need to modify e.g. the value of the object H.Flow1 already archived. If you have used the first method, you must also manually change the value of the historical value. The second method automatically recalculates the expression and corrects the sum.

Calculation methods

Definition of a methods to calculate given expression - periodically or on value change. If the option On value change is selected, the expression will be recalculated when a value of at least one objects defined in the expression is changed.

Object of Historical value type defined in this way can be either simple or one-column historical value. If the object is one-column historical value, the expression may also contain the references to other structured or one-column historical values with the row index of 0. During the calculation, the index is dynamically replaced by current row number of the one-column historical value to recalculate. That allows to define the same expression for all column items.

Publish values

If the option Publish values is checked, than the historical value will publish its last value:

Archive size

Definition of archive size - see the parameter Publish values. The parameter will appear, if the parameter Publish values is not checked.

Target column

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.


FILL ARCHIVE FROM SCRIPT (VALUE STORAGE)

Object of Historical value type filled from a script can be used as a storage of values which are not generated by archiving the values of other D2000 system object, statistical calculation or other expression calculation. Values can be only filled from an ESL script or manually from the process D2000 HI.

Value storage can be simple, one-column or structured one. This is given by the parameter Archive structure or Target structure (it depends on the parameter Publish values)

Inserted values are periodical

If the option is checked, you must define a period and offset (the tab Time parameters).

Publish values

Checking the option Publish values "renames" the parameter Archive structure to Target structure. The functionality of the parameter to define the archive is not changed, but it is not possible to define an object of Historical value type.
If the option Publish values is checked, the parameter Target structure defines whether the historical value is simple or structured one. If Target structure is not defined, the historical value is a simple one and gets the last value. If it is defined, the historical value is a structured one and will fill last value into the respective item of defined structured variable.

Archive playback

The parameter is enabled when the parameters Inserted values are periodical and Publish values are checked. If it is checked, the historical value will not publish its last value but the value that is valid according to the current time (e.g. from a ESL script, the feature allows to fill an object of Historical value type with values containing the future timestamps and the object "plays" them in real time).

Archive structure

The parameter appears when the parameter Publish values is not checked.

Target structure

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.

Statement


In the top part of the tab, there is placed the input edit filed for entering the expression, that determines the value of the historical value. The expression can contains functions, constants, attributes but objects of Historical value type only. The expression may also contain the extended syntax.

Objects

The button allows to select an object of D2000 system. Selected object is to be inserted into the expression on the current cursor position.
Note: Expression can contain objects of Historical value type only.

Constants

The button allows to select a constant. Clicking it open the dialog box containing the list of predefined constant. Selected constant is to be inserted into the expression on the current cursor position.

Functions

The button allows to select a function. Clicking it opens the List of functions dialog box. Selected function is to be inserted into the expression on the current cursor position.

Attributes

The button allows to select an attribute. Clicking it open the dialog box containing the list of attributes. Selected attribute is to be inserted into the expression on the current cursor position.

Replace Invalid values with 0

If checked, all invalid values of the objects defined in the expression will be replaced with the value of 0. The feature can be used to prevent the expression from getting invalid value. There are converted just the values of input objects, invalid values of intermediate data are not converted. Values of inputs objects are converted as follows:

Other value types are not converted.

Maximum density of evaluation [s]

The parameter can be defined for the archive method Filter. It allows to restrict the number of evaluations of given expression so that the expression will be evaluated once within defined time. It is used especially in cases, when the values of the objects defined in the expression are often changed and calculating the expression is not required immediately. It is used especially in cases, when the values of the objects defined in the expression are often changed and calculating the expression is not required immediately.

Calculation

Method of the statement calculation:

Time parameters


Archiving period

The parameters define the period (Hours : Minutes : Seconds) and the time offset within the period for the periodical primary and statistical archiving method (Hours : Minutes : Seconds).

History depth

Archiving time (Months : Days : Hours). The parameter determines the archiving time depth. It is the minimal time period, during which the data will be stored in the on-line archive. The older data are being erased from the archive.

The maximum history depth is 800 months (approximately 66 years).

Stored time

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 directly affect anything - the data has a time stamp with which it was stored from the script. It however affects the calculation of statistics and whether statistics are calculated from the value at the edge of the interval.

Conditions


Defining the conditions for the start and interruption of the archiving is provided by the mechanism of the object archiving dynamical control depending on values or states of others objects in the system. Both conditions need not have to be defined. If not defined, the archiving will be started immediately after the start and initialisation of the process Archive.

Start condition

Defining the condition causing the start of the given historical value.

The object representing the archiving start condition may be defined by several ways:

Also, it is necessary to define, for what state of the given object is the condition valid. In the list under the object entry field, there are displayed possible object value states. This list is different for various  kinds of types of objects. The archiving start condition will be valid, if the object is in the chosen state. If the option Inverse function is enabled, the condition is valid, if the object is in status other than the chosen state.

Stop condition

Defining the condition that causes stopping the archiving of the given historical value.

The object representing the archiving stop condition may be defined by several ways:

Also, it is necessary to define, for what state of the given object is the condition valid. In the list under the object entry field, there are displayed possible object value states. This list is different for various  kinds of types of objects. The archiving stop condition will be valid, if the object is in the chosen state. If the option Inverse function is enabled, the condition is valid, if the object is in status other than the chosen state.

Statistics


Statistical function

When archiving into the statistical archive it is possible to use these implemented functions.

FunctionMeaning
NoneNo function.
Average *Arithmetical average of all archive object values.
W-Average *Weighted arithmetical average of all archive object values.
IntegralTime integral of historical values.
SumSum of archive object values.
MaximumMaximum of archive object values.
MinimumMinimum of archive object values.
CountNumber of archive object values.
FilterApplying a filter for value storing into the statistical archive.
Increment

If the newer value is greater than the older one, then the difference between the values, otherwise the newer value (the function is useful to process counter values that oveflow and start from zero again).
Parameter (Compare value) – weight of impulse. The result will be the impulse multiplied by its weight. Weight of 1 will ensure standard behaviour.

DeltaDelta between values. Parameter (Compare value) – weight of impulse.
The result will be the impulse multiplied by its weight. Weight of 1 will ensure standard behaviour.
EcoAvgAverage of the object values within the elapsed time period (Period parameter in Time parameters tab) according the methodology based on flags of individual values entering the statistic. The same purpose is fulfilled by the function %EcoAveR, that is implemented for eval tags.
GT Time (>)The function calculates the time, during which the value of the historical value was greater than the entered constant (Compare value).
GE Time (>=)The function calculates the time, during which the value of the historical value was greater or equal to the entered constant (Compare value).
LT Time (<)The function calculates the time, during which the value of the historical value was lower then the entered constant (Compare value).
LE Time (<=)The function calculates the time, during which the value of the historical value was lower or equal to the entered constant (Compare value).
Maximum in time intervalObsolete - do not use!
Minimum in time intervalObsolete - do not use!
Number of local maximums
Number of local minimums
Sum of positive valuesSum of positive values of the historical value.
Sum of negative valuesSum of negative values of the historical value.
Average of positive valuesArithmetical average of positive values of the historical value.
Average of negative valuesArithmetical average of negative values of the historical value.
Sum of incrementsSum of increments for given time interval. If the new value is less than the old value, the increment is 0.
Parameter (Compare value) – weight of impulse.
The result will be the impulse multiplied by its weight. Weight of 1 will ensure standard behaviour.
Time slice**Object value in given time moments.
Sample standard deviationThe function calculates the sample standard deviation of all values of the archive object.

* For non-periodical values we recommend you to use the W-Average (weighted average) function and the Average function for periodical values.
** The function allows recalculation of the historical value if historical values archived primarily have been changed.


The difference among the functions INCREMENT, DELTA and SUM OF INCREMENTS is shown in the following figures.

In the first case, all three functions are equal to 5 (10-5)

In the second case

In the third case

Calculation

Statistics calculation method:

Validation criteria

The value of the parameter Validation criteria defines the value percentage in the primary archive (used fro the calculation of values stored into the statistical archive) that has to be valid, in order to acquire a valid result. If there were less valid values than stated in Validity criteria, the result will be Weak_Value.


Time interval for statistical calculation

Statistical time period defines the time interval, the set of historical values, that will be processed by the particular statistical function. By default, the interval is equal with the archiving period. If it is necessary to enter different period, check the option Time interval different from archiving period and enter required period into the parameter Interval. The time period must be greater than 0 [s].

Compare value

A parameter for the functions GT Time (>), GE Time (>=), LT Time (<), LE Time (<=).

Integral time units

A parameter for the function INTEGRAL:

Filter


The system allows to archive considerable value changes of the archive object. This archiving method represents defining of three deadband levels, that are possible to set various values of significant changes.




Values of filtering:

Historical values