Setting benchmarks for data rules

You can set a validity benchmark either when you initially create a rule definition, or when you generate the data rule, in order to quantify the quality of your data, as well as monitor your data.

Validity benchmark

The validity benchmark establishes the level or tolerance you have for exceptions to the data rule. The benchmark indicates whether sufficient records have met or not met the rule in order to mark a specific execution of the rule as having passed or failed to meet the benchmark.

Select Monitor records that do not meet one or more rules in the data rule workspace.

You can define the validity benchmark by using the following options that can be found in the menu in the validity benchmark workspace. Start by selecting one of the following options:

% Not Met: Determines the percentage of records that did not meet the rule logic in the data rule. You can set the benchmark to display a pass or fail condition when this value is greater than, less than, or equal to a reference value that you specify. For example, to ensure that the percentage of records that do not meet a data rule never exceeds or falls below 10%, you would set the benchmark to "% Not Met % <= 10."
# Not Met: Determines the number of records that did not meet the rule logic in your data rule. You can set the benchmark to display a pass or fail condition when this value is greater than, less than, or equal to a reference value that you specify. For example, to ensure that the percentage of records that do not meet a data rule never exceeds or falls below 1000, you would set the benchmark to "# Not Met <= 1000."
% Met: Determines the percentage of records that meet the rule logic in your data rule. You can set the benchmark to display a pass or fail condition when this value is greater than, less than, or equal to a reference value that you specify. For example, to ensure that the percentage of records that meet the data rule never falls below 90%, you would set the benchmark to "Met % >= 90."
# Met: Determines the number of records that meet the rule logic in your data rule. You can set the benchmark to display a pass or fail condition when this value is greater than, less than, or equal to a reference value that you specify. For example, to ensure that the number of records that meet the data rule never falls below 9000, you would set the benchmark to "Met # >= 9000."