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 represent the type of column that contains the business data.
5. Configure the condition.
- - Click the condition icon to 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.
6. 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
7. Configure the action to write a value when the input data contains a reference table value.
- - Click the action icon to open the Define Action dialog box.
- - Select Input.
- - Specify the type of data to enter. Use string data to return a text value.
- - Enter a data value. For example, enter "VALID."
- - Click OK.
8. Save the rule specification.