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