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."