Checking rules

Introduction

Checking rules allow you to validate data present in a dataset according to one or several criteria defined by the user and based on the dataset fields.

The following check elements can be defined for each rule:

• the type of check to be performed, the operator and the elements to be checked, potentially filtered
• a set of condition fields that contains dataset fields on which filters can be set in order to identify the values to be checked
• a set of grouping fields which contains the combination of dimensions with which to group the values to be checked

Types of checking rule

Checking rules are divided into the following types.

Rule type	Description
Existence rule	Checks that the value of every set of records is present and not 0.
Coherence rule	Checks that the value for the second set of data is also present, in addition to checking that the value of the first set of data is present and not 0.
Congruence rule	Checks, through comparison and according to the defined operator, that the difference between the values obtained from the first and second set of data is within the specified threshold.