To verify the accuracy of a column of business data, configure a rule statement that compares the column to a dictionary. For example, you might configure a rule statement to verify that a data column contains the current product codes for the organization.
1Select a rule set in a rule specification.
2In the rule set properties, click Rule Logic.
3Click Add Rule Statement.
4Select an input for the rule statement.
- If the rule specification does not contain an input that you can use, create an input. Configure the input properties to represent the type of column that contains the business data.
5Select an operator to validate the results of the condition analysis.
- To identify input values that match the dictionary values, select the following operator:
is within
6Select the type of condition to apply to the input.
- To use a dictionary in a condition, select the following condition type:
function
7Configure the condition to apply a dictionary to the input data.
- Open the Define Condition dialog box.
- Select Dictionary.
- Browse to the dictionary that contains the standard versions of the business data.
For example, select a dictionary that contains a set of product codes.
- Select or clear the option to perform a case-sensitive search of the dictionary.
- Click OK.
8Select the type of action to apply to the data that satisfies the condition logic.
- To return a string value, select the following action type:
string value
9Enter the value that the action returns. For example, enter VALID.