Adding a Rule Set or Editing a Rule Set

You typically manage Data Quality Analysis rule sets through the Rule Set Manager.

Procedure

To add a new rule set or edit an existing rule set:

  1. Open the Rule Set Manager.
  2. There are several ways to add a new rule set or edit an existing rule set:

    • To add a new rule set, click Add New and then select the rule set type. The Rule Set Editor window opens so that you can configure the new rule.

    • To add a new rule set that is based on an existing rule set, right-click on an existing rule set and then select Add New … From Selected. When the Rule Set Editor opens, rename the rule set or save it under a different name, and then configure the new rule.

    • To open or edit an existing rule set, right-click on the rule set and then select Open / Edit. The Rule Set Editor window opens so that you can view or edit the rule.

    • To edit rule sets via the Data Quality Analysis user interface, select the Validate Data or Augment diagnostic, select a Completeness or Reasonability rule set, click Options, and then make changes in the Rule Set Editor.

  3. Save the rule set changes.

    Rule sets are stored on the same database server as the CEDE database where you are running the analysis. Therefore, if you switch database servers at any time while using Data Quality Analysis, a different list of rule sets will be available to you. While a rule set on one server can have the same name as a rule set on another server, AIR recommends that you avoid confusion by giving unique names to all rule sets.