Check with dictionary

Function and purpose of the operation

The Check with dictionary operation checks that the content of a dimension associated with a dictionary is consistent with the dictionary itself. For every dimension, the operation checks that its values are coherent for the entire defined dictionary.

If the option All fields with dictionary is selected on the operations page, the system checks all fields containing a dictionary.

Note: Does not handle dependent dictionaries.

IMPORTANT: When the operation detects values that are not present in the dictionary for at least one dimension, the system displays an error message in the audit along with the top 10 rows containing the missing codes.

Operation behaviour

The following scenarios may occur during execution:

• No inconsistencies detected: the operation is successful.
• Inconsistencies detected: the operation returns a warning, the system displays in the audit the error message along with the details of the top 10 rows in the dataset with inconsistencies.

IMPORTANT: If DTP is launched from the cockpit and inconsistencies are found, the system generates a report file of the anomalies found. For further details see DTP Report.

Example without differences

Dataset

Name	Surname	Age	Region
Marco	Rossi	34	Lombardia
Elena	Bianchi	29	Toscana
Luca	Gallo	41	Lazio

Where the dictionary checks the Region column and contains all Italian regions.

The operation is successful and no difference is reported.

Example with differences

Dataset

Name	Surname	Age	Region
Marco	Rossi	34	Lombardia
Elena	Bianchi	29	Toscana
Luca	Gallo	41	Lazio
Sara	Neri	36	France
Chiara	Fontana	38	Italy

Where the dictionary checks the Region column and contains all Italian regions.

The data processing finds differences and ends with a warning highlighting the top 10 differences in the audit:

Name	Surname	Age	Region
Sara	Neri	36	France
Chiara	Fontana	38	Italy