Activity | Area | Description |
---|---|---|
Activate data quality policy version |
Data quality | When the full setup of a data quality policy version is finished, to apply the defined rules, you must make the version active. Note: You cannot edit an active data quality policy version.
|
Copy data quality policy |
Data quality | Use data quality policies to ensure that your data is of the desired quality. You can organize data quality policies, for example, by functional area, business process owner, or organization assignment. To create a data quality policy, you can copy an existing one. When you copy a data quality policy, you must choose which versions you want to copy. In the new data quality policy, the chosen versions are added in the version sequence of the original data quality policy. Example: You copy versions 4 and 6 of the original data quality policy. In the new data quality policy, version 4 is added as version 1, and version 6 is added as version 2.
|
Create data quality policy |
Data quality | Use data quality policies to ensure that your data is of the desired quality. You can organize data quality policies, for example, by functional area, business process owner, or organization assignment. If you create a data quality policy, its header and first version are created. |
Create data quality policy version |
Data quality | You can create a new version for a data quality policy. If you create a new version, you can choose to:
A data quality policy version contains all elements of a data quality policy, except for the data quality policy header. These elements are version-specific:
|
Create dynamic query with the Wizard |
Data quality | 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:
You can also start the dynamic query wizard from an existing query to edit it. |
Delete data quality policy |
Data quality | You can delete or retire a data quality policy. If you try to delete a data quality policy:
|
Develop custom action class |
Data quality | You can use a custom action rule to set a field value using a custom class. To set up a custom action rule, first develop the custom class to be applied. The custom class must extend the DQSCustomValidationBase base class. When you extend the DQSCustomValidationBase base class:
|
Develop custom parameter value class |
Data quality | To define a web service parameter value, you can use a custom class to return a parameter value. You can use a custom parameter value class to return web service parameters for validation rules and action rules of type Web service. The custom parameter value class must extend the DQSWebServiceParametersBase base class. This custom class must have at least one return method that returns a value. |
Develop custom response or request handler class |
Data quality |
For a web service, you can use a custom class to define the:
The custom class must extend the DQSWebServiceCustomFormatBase base class.
|
Develop custom validation class |
Data quality | You can use a custom validation rule to validate a field value using a custom validation class. To set up a custom validation rule, first develop the custom validation class to be applied. The custom validation class must extend the DQSCustomValidationBase base class. When you extend the DQSCustomValidationBase base class:
The base structure of an extended DQSCustomValidationBase class is: |
Develop function class |
Data quality | You can use a function to fill the value of a condition on a query range. For a function, a class is required. To develop this class, extend the DQFFunctionRun class. Prerequisite: Develop the extension of the DQFFunctionRun class in the AOT before you start the steps. Note: The steps are to have the developed function class uploaded as function. |
Process quality assessment results |
Data quality | As a data owner, you can review and process data quality assessment results. A data owner can be a:
You review the data quality assessment results:
For each:
|
Run data quality assessment |
Data quality | You can run a data quality assessment to examine the quality of existing data. To run a data quality assessment, you use data quality assessment projects. You can do a data quality assessment, for example, if you:
|
Set up action rule conditions |
Data quality | 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:
You can set up several conditions, using different query types. |
Set up action rule of type Custom |
Data quality | 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 Custom. 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 |
Data quality | 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 Fixed value |
Data quality | 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 Fixed value. Use a Fixed value action rule to set a pre-defined fixed value in the target field of the action rule.
|
Set up action rule of type Number sequence |
Data quality | Use action rules to set field values in D365 FO. Use a number sequence action rule to set the value of the target field of the action rule based on a number sequence.
|
Set up action rule of type Transformation list |
Data quality | 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.
Example:
You can set up a transformation list to transform country codes into the relevant currencies for these countries. In this case, the source field is a country field, and the target field is a currency field. If the country is US, and the transformation list action rule is applied, the currency is set to USD.
|
Set up action rule of type Web service |
Data quality | 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.
You can set up a web service action rule in several ways. For a parameter of type:
|
Set up condition table mapping |
Data quality | On data quality policy rules, you can define conditions. If you define a condition and the applicable table for the rule is a date-effective or inheritance table, additional setup is required. The applicable table for the rule must be mapped to a related staging table or temporary table. For example, if the applicable table for the rule is the:
|
Set up configurable lookup - Dynamic query |
Data quality | You can set up a configurable lookup of type 'Dynamic query' to define the possible options in a field with a dynamic query. |
Set up configurable lookup - User defined list |
Data quality | You can set up a configurable lookup of type 'User defined list' to manually define the possible options in a field. |
Set up data pattern |
Data quality | You can use a data pattern validation rule to validate if a field value matches a defined pattern. To set up a data pattern validation rule, first set up the data pattern to be applied. Define the data pattern, using a regular expression. You can, for example, set up data patterns to validate:
For more information on regular expressions, refer to Regular expression. |
Set up data quality assessment project |
Data quality | You can use a data quality assessment project to examine the quality of existing data. You can do a data quality assessment, for example, if you:
In a data quality assessment project, you can apply:
|
Set up 'Data quality' organization hierarchy purpose |
Data quality | 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 duplicate check |
Data quality | To set up a duplicate check rule, a duplicate check is required. If the desired duplicate check does not exist, set up a new duplicate check. For each duplicate check, define which combination of table fields is checked on duplicate values. So, the combination of field values must be unique in the table. |
Set up duplicate check rule |
Data quality | 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. So, the combination of field values must be unique in the table. |
Set up duplicate check rule conditions |
Data quality | 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:
You can set up several conditions, using different query types. |
Set up organization assignment for Data quality policy |
Data quality | 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. To set up the organization assignment, you can use legal entities or organization hierarchies. Before you can use an organization hierarchy, assign the desired organization hierarchy to the 'Data quality' organization hierarchy purpose. |
Set up reason codes |
Data quality | If you do data quality assessments, for an error or warning, you can set the status to 'Accept deviation'. In this case, it is important to explain why you accept the deviation. You can do so, by selecting a reason code. This topic explains how to set up the reason codes. |
Set up secured values |
Data quality | You can set up secured values to store secrets at a central place in Data quality studio. You can , for example, set up a secured value for a license key or access token. Benefits of using secured values are:
In Data quality studio, you can use secured values as a parameter for web services. |
Set up transformation list |
Data quality | To set up a transformation list action rule, a transformation list is required. If the desired value transformation does not exist, set up a new transformation list or add the transformation to an existing transformation list.
For each transformation list, set up the value transformations. For each value transformation, define the source value and the target value. Example: You can set up a transformation list to transform country codes into the relevant currencies for these countries. In this case, the source field is a country field, and the target field is a currency field. If the country is US, and the transformation list action rule is applied, the currency is set to USD.
|
Set up validation rule conditions |
Data quality | 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:
You can set up several conditions, using different query types. |
Set up validation rule message |
Data quality | You can define a message that is shown if the validation rule is not met. If no validation rule message is defined, the default message is shown if the validation is not met. In case of a data pattern validation, the applicable data pattern can also have a message defined. In this case, the message priority is:
You can also enter a description of the validation rule. You can translate both the validation message and the validation rule description. |
Set up validation rule of type Configurable lookup |
Data quality | 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 |
Data quality | Use validation rules to check if the data is in line with the defined standards. Use a custom validation rule 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 |
Data quality | Use validation rules to check if the data is in line with the defined standards. Use a data pattern validation rule 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 Mandatory or Blank |
Data quality | 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 validation rules of these types:
|
Set up validation rule of type Range expression |
Data quality | 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 a validation rule of type Range expression.
Use a range expression validation rule to validate if a field value is within a defined range. To define a range expression, you can use a:
For more information on how to define ranges in the Range expression field, refer to Advanced filtering and query syntax.
|
Set up validation rule of type Web service |
Data quality | Use validation rules to check if the data is in line with the defined standards. Use a web service validation rule to validate if a field value matches a value in another internal or external source, using a web service.
You can, for example, use a web service validation rule to validate an address, email, or VAT number.
Before you can set up a web service validation rule, set up the web service to be used.
You can set up a web service validation rule in several ways. For a parameter of type:
|
Set up web service for Data quality studio |
Data quality | You can use a web service in:
To set up a web service validation rule or action rule, first set up the web service to be used. You can find most of the required values to be set for the web service in the technical documentation as shared by the web service provider. |
View quality assessment exceptions log |
Data quality | As a data owner, you can review and process data quality assessment results. A data owner can be a:
You can review the full unfiltered list of data quality assessment results. Using this list, you can:
|