An advanced rule association is an association between attribute values and a Cloud Data Quality rule specification. You can use the predefined rule specifications or create custom rule specifications in Cloud Data Quality. For more information about rule specifications in Cloud Data Quality, see Rule specification assets in Cloud Data Quality.
For example, you work for an organization as a Governance Lead. To retire the old general ledger accounts created before 2012, you configure advanced rule associations based on the account creation date. These rule associations update the status of accounts created before 2012 to Retired.
To learn how to create rule specifications in Cloud Data Quality and validate reference data using the rule specifications in Reference 360, see the following video:
Rules and guidelines for advanced rule associations
Consider the following rules and guidelines when you define advanced rule associations:
•When a rule specification is modified in Cloud Data Quality, select the rule specification again or reset the fields of the advanced rule association in Reference 360. Otherwise, the changes to the rule specification aren't effective when the rule is executed.
•If you set an attribute as input and output fields for the same advanced rule association, you can't add values for the fields that use the rule specification, on the New Code Value page. To add code values to a code list, you can use reference data import jobs.
•When you configure an advanced rule association for a reference data field or a field that uses a reference data field, the rule considers only the code field of the referenced code value.
• When you re-enable the advanced rule association for the Code attribute and update a field other than the input fields, you can't save the code value if the input fields were updated previously.
To save the code value, perform one of the following actions:
- Disable the advanced rule association.
- Revert the changes to the input fields and re-enable the advanced rule association.
•By default, Cloud Data Quality uses the Date/Time format to execute rules. When you configure advanced rule associations to validate date fields in Reference 360, the rules consider the date based on the time zone. For example, when you configure an advanced rule association to check whether the date is earlier than the current date. The rule considers the time zone and determines the date.
•To ensure the success of the comparison operation for the code value field in Reference 360, use integer or string values in the rule statement output of the advanced rule association. If you use a float value in the rule statement output, specify additional decimal values in the Rule is Valid when Status Is field.
•An advanced rule association for a transformation function must have rule statement output values for all the conditions in Cloud Data Quality to generate values in the output field.
•After you configure an advanced rule association to code list attributes, specify values in the rule applied field to run the rule and display validation error messages for code values.
•When you set the code field as the output field for an advanced rule association, if you import code values, calculate the rule execution result and provide values for the code field. Ensure that the values you provide don't mismatch with the values the rule generates.
• When you configure an advanced rule association for a required field, ensure that the field value doesn't depend on the value of another field that is configured with an advanced rule association. Reference 360 doesn't guarantee the execution order of the rules.
Add advanced rule associations
Use Cloud Data Quality rule specifications to add advanced rule associations for code list attributes. You can associate a rule specification as a transformation rule or a validation rule.
1Open a code list.
2Click Definition.
The Definition tab opens.
3In the Attributes section, select the attribute to add a rule.
The Attribute Details panel displays the details of the attribute on the Details tab.
4On the Advanced Rules tab, click the Add icon.
A form appears.
5Select a rule specification.
aClick the asset picker.
The Select an Asset page appears.
bSelect a rule specification, and click Select.
6Enter a unique name for the rule association.
7Optionally, enter a description.
8On the Input and Output Fields tab, perform the following tasks:
aIn the Input Fields section, select a business entity field or enter an input value for each rule specification input field.
bIn the Output Fields section, select a business entity field for each rule specification output field if you want to associate a transformation rule.
If you associate a transformation rule by specifying a value in the Output Fields section, the Validation tab is disabled.
9To associate a validation rule, specify values on the Validation tab without providing values in the Output Fields section.
aIn the Rule Status section, select a rule specification field that contains the validation status.
b Enter a validation status that indicates successful validation.
Note: Ensure that the validation status matches the rule specification output value for successful validation.
cIn the Error Status section, configure the error message by using one of the following ways:
▪ Select a rule specification field that contains an error message.