Check : check

Syntax

check ( op { errorcode errorcode } { errorlevel errorlevel } { imbalance imbalance } { output } )

output ::= invalid | all

Input parameters

op	a boolean Data Set (a boolean condition expressed on one or more Data Sets)
errorcode	the error code to be produced when the condition evaluates to FALSE. It must be a valid value of the errorcode_vd Value Domain (or string if the errorcode_vd Value Domain is not found). It can be a Data Set or a scalar. If not specified then errorcode is NULL.
errorlevel	the error level to be produced when the condition evaluates to FALSE. It must be a valid value of the errorlevel_vd Value Domain (or integer if the errorcode_vd Value Domain is not found). It can be a Data Set or a scalar. If not specified then errorlevel is NULL.
imbalance	the imbalance to be computed. imbalance is a numeric mono-measure Data Set with the same Identifiers of op. If not specified then imbalance is NULL.
output	specifies which Data Points are returned in the resulting Data Set: · invalid returns the Data Points of op for which the condition evaluates to FALSE · all returns all Data Points of op If not specified then output is all.

Examples of valid syntaxes

check ( DS1 > DS2 errorcode myerrorcode errorlevel myerrorlevel imbalance DS1 - DS2  invalid )

Input parameters type

op

dataset

errorcode

errorcode_vd

errorlevel

errorlevel_vd

imbalance

number

Result type

result

dataset

Additional Constraints

op has exactly a boolean Measure Component.

Behaviour

It returns a Data Set having the following components:

the Identifier Components of op
a boolean Measure named bool_var that contains the result of the evaluation of the boolean dataset op
the Measure imbalance that contains the specified imbalance
the Measure errorcode that contains the specified errorcode
the Measure errorlevel that contains the specified errorlevel

If output is all then all data points are returned. If output is invalid then only the Data Points where bool_var is FALSE are returned.

Examples

Given the Data Sets DS_1 and DS_2:

Input DS_1 (see structure)

Id_1	Id_2	Me_1
2010	I	1
2011	I	2
2012	I	10
2013	I	4
2014	I	5
2015	I	6
2010	D	25
2011	D	35
2012	D	45
2013	D	55
2014	D	50
2015	D	75

Input DS_2 (see structure)

Id_1	Id_2	Me_1
2010	I	9
2011	I	2
2012	I	10
2013	I	7
2014	I	5
2015	I	6
2010	D	50
2011	D	35
2012	D	40
2013	D	55
2014	D	65
2015	D	75

Example 1

DS_r := check ( DS_1 >= DS_2 imbalance DS_1 - DS_2 );

results in (see structure):

DS_r
Id_1	Id_2	bool_var	imbalance
2010	I	false	-8
2011	I	true	0
2012	I	true	0
2013	I	false	-3
2014	I	true	0
2015	I	true	0
2010	D	false	-25
2011	D	true	0
2012	D	true	5
2013	D	true	0
2014	D	false	-15
2015	D	true	0