Building data rule definitions with the rule builder

Use the rule builder to select a variety of predefined rule definition combinations to build your rule logic.

1. Click the Develop icon on the Navigator menu in the console, and select Data Quality.
2. Click New Data Rule Definition or open an existing logical rule definition.
3. Click the Rule Logic tab.
4. Optional: The first field to the left of the screen is the Condition. This condition field contains logic operation options. Choose the condition IF or NOT, or leave this field blank. This field is most often used to connect two lines of logic on the rule building menu.
5. Optional: The next field is the parenthesis “(“ icon. This is a logical operation feature for compound logic, and is used for nested conditional statements. Select (, ((, or ((( for the next sequence in the creation of your rule definition, or leave this field blank if you do not need to create nested conditional statements.
6. Selecting your source data is the next part of the sequence. Go to the Source Data field, and either type a name for your local variables in this field, or go to the Tabbed Palette menu on the right side of the screen. From this menu you can select your source data from the Data Sources, Global Logical Variables, Terms, or Functions tabs. Note: You can select both a data source and a function from the Tabbed Palette menu for the Source Data field. For example, you can select the column "Salary" from one of your data sources and the function "AVG(value)" as a combined value for your Source Data field. Type "salary" to override the "value" default value so the expression reads "AVG(salary)." The Source Data value would become the average value of the "Salary" column. You can build rule logic by using the Tabbed Palette as shown in the following figure:
   Figure 1. Building a data rule definition by using the Tabbed Palette

   
7. Optional: The next icon is another Condition menu. This condition option is for inverse rule logic. Select the “NOT” option to create a rule definition that sets a negative condition, or leave this field blank.
8. Type of Check is the next building option. The Type of Check options include equals, contains, exists, and is_numeric. Choose the type of check that you want to use for this rule logic.
9. Type the Reference Data that you want to use in the Reference Data field. You can also go to the Tabbed Palette menu in the right side of the screen. From this screen select an entry for this field from the Data Sources, Global Logical Variables, Terms, or Functions tabs.
10. Optional: Click the second Parenthesis tab to close any open parenthesis or leave this field blank.
11. You can continue to build new rule logic in each row in the interface. Go to the next line on the rule logic builder screen, and select AND, ELSE, OR, THEN, or, NOT in the Condition field.
12. Select Save or Save and Close. The list of data rule definitions, rule set definitions, data rules, metrics and monitors is displayed. The data rule definition that you created is added to the folder you were working in.