Flow | Description |
---|---|
Apply data quality rules on data quality assessment |
You can run a data quality assessment project to examine the quality of existing data. You can do a data quality assessment, for example, if you:
|
Set up action rule conditions |
For each action rule, you can set up conditions. The action rule is only applied if the conditions are met. To define an action rule condition, you use a query. The action rule is applied only to the records that are found by the query. You can use these types of queries:
|
Set up action rule of type Custom |
Use action rules to set field values in D365 FO. Use a custom action rule to set a field value using a custom class.
Before you can set up a custom action rule, ensure that the custom class is developed. |
Set up action rule of type Data query |
Use action rules to set field values in D365 FO. Use a data query action rule to find a value using a query and set the found value in the target field of the action rule.
You can use these types of queries:
|
Set up action rule of type Transformation list |
Use action rules to set field values in D365 FO. To set a field value, you can use several action types. This topic explains how to set up an action rule of type Transformation list.
Use a transformation list action rule to find a value using a transformation list and set the found value in the target field of the action rule.
Before you can set up a transformation list action rule, set up the transformation list to be used. |
Set up action rule of type Web service |
Use action rules to set field values in D365 FO. To set a field value, you can use several action types. This topic explains how to set up an action rule of type Web service.
Use a web service action rule to get a field value from another internal or external source, using a web service, and set this value in the target field of the action rule.
Before you can set up a web service action rule, set up the web service to be used.
|
Set up action rules |
Use action rules to set field values in a target field in D365 FO.
For each action rule, you can set up conditions to define the data to which the rule applies. |
Set up configurable lookup |
You can set up a configurable lookup to define the possible options in a field. You can define the possible options for a configurable lookup in these ways:
To apply a configurable lookup, set up a validation rule of type Configurable lookup. You can use a configurable lookup on several validation rules. This topic explains how to set up a configurable lookup. |
Set up data quality policy versions |
A data quality policy has one or more versions. A data quality policy version contains all elements of a data quality policy, except for the data quality policy header. These data quality policy elements are version-specific:
Element-specific setup:
|
Set up duplicate check rule conditions |
For each duplicate check rule, you can set up conditions. The duplicate check rule is only applied if the conditions are met. To define a duplicate check rule condition, you use a query. The duplicate check rule is applied only to the records that are found by the query. You can use these types of queries:
|
Set up duplicate check rules |
Use a duplicate check rule to check if the data doesn't already exist in the table. Before you can set up a duplicate check rule, set up the duplicate check to be applied. A duplicate check defines which combination of table fields is checked on duplicate values.
|
Set up dynamic queries |
Use a dynamic query to find one or more records in the database. The found records are the input for further processing. You can use a dynamic query on:
To define a query range, you can use a function. |
Set up organization assignment for Data quality policy |
By default, a data quality policy version is applied to all organizations as defined in the current D365 FO environment. If a data quality policy version must be applied only to specific organizations, set up the organization assignment. You can apply a data quality policy version to (a part of) an organization hierarchy. Before you can do so, assign the desired organization hierarchy to the 'Data quality' organization hierarchy purpose. |
Set up validation rule conditions |
For each validation rule, you can set up conditions. The validation rule is only applied if the conditions are met. To define a validation rule condition, you use a query. The validation rule is applied only to the records that are found by the query. You can use these types of queries:
|
Set up validation rule of type Configurable lookup |
Use validation rules to check if the data is in line with the defined standards. Use a configurable lookup validation to add a custom lookup to a field and to validate if the field value matches a value as defined by the configurable lookup. Note: If the field, to which the configurable lookup is applied, already has a lookup, the configurable lookup overwrites the existing lookup. Before you can set up a configurable lookup validation rule, set up the configurable lookup to be used. |
Set up validation rule of type Custom |
Use validation rules to check if the data is in line with the defined standards.
To validate data, you can use several validation types. This topic explains how to set up the Custom validation type. Use a custom validation to validate a field value using a custom validation class.
Before you can set up a custom validation rule, ensure that the custom validation class is developed. |
Set up validation rule of type Data pattern |
Use validation rules to check if the data is in line with the defined standards. Use a data pattern validation to validate if a field value matches a defined pattern.
Before you can set up a data pattern validation rule, set up the data pattern to be applied.
|
Set up validation rule of type Web service |
Use validation rules to check if the data is in line with the defined standards. Use a web service validation to validate if a field value matches a value in another internal or external source, using a web service.
Before you can set up a web service validation rule, set up the web service to be used.
|
Set up validation rules |
Use validation rules to check if the data is in line with the defined standards. To validate data, you can use these validation types:
For each validation rule, you can set up:
|