option. After you create rule occurrences, you must save and run the profile. You can use only rule specifications to create a rule occurrence and other
Data Quality
assets or mapplets cannot be used.
You can create rule occurrences on a profile with rules that have single or multiple output fields. To create a rule occurrence with multiple output fields, select an output field that is marked as available.
Data Profiling
marks the output field name as available to indicate that the scorecard uses it. The output field name is marked available and ranked in precedence in the following order: isValid, isTrue, out_valid, out_status, PrimaryRuleSet.
Data Profiling
does not list rules with multiple output fields on the
Metrics
tab, if the field names are not isValid, isTrue, out_valid, out_status, or PrimaryRuleSet.
Perform the following steps to create a rule occurrence:
On the
Metrics
tab, click Add (
).
In the
Create Rule Occurrence
dialog box, choose a rule specification output to measure. You can either select a single output field or multiple output field.
Click
Next
.
In the
Create Rule Occurrence
dialog box, perform the following steps:
Specify a name and description for the rule occurrence in the
General Details
section.
Define valid threshold values for scorecard generation in the
Rule Occurrence Thresholds
section. You can modify a threshold after you create a rule occurrence without running the profile again.
Click
OK
.
The rule appears on the
Rule Occurrences
tab.
Continue to add more rule occurrences to the
Rule Occurrences
tab as necessary.
Choose one of the following options to save and run the profile:
Click
Save
to save the profile.
Click
Run
to save and run the profile.
You can view the scorecard results only when you run the profile again after you create or update rule occurrences.
When you delete a rule that is associated with a data profiling task, the corresponding rule occurrences are automatically deleted from the profile.