Creating Attribute Business Rules - trillium_discovery - trillium_quality - 17.2

To create an ABR

1. In the Navigation View, click the Discover bar.
2. To open the Expression Builder, do one of the following:
   • Right-click an attribute and select Business rules > Add attribute business rule.
   • From the Library tab, expand Business Rules and Attribute Business Rules. Right-click an attribute and select Add rule.
   • Right-click in an attribute's List View of ABRs, and select Add rule.

   The Expression Builder opens, with the Enabled check box selected.

3. (Optional) Clear the Enabled check box.
   Note: When a rule is not enabled, it remains in the attribute but cannot be re-analyzed.
4. In Name, enter the name of the business rule.
5. In Description, enter a description of the rule and what it does. Click the button to open a text window to better view long descriptions.
6. In Threshold:, enter a percentage value that should comply with this business rule, and select either Rows or Values threshold type.
7. For Priority, select a number from the drop-down list. This value correlates with the level of importance you want to associate with the rule.

   For example

   , if you have priorities 1 through 10, you could use 1 through 5 for rules with higher importance, with 1 being most important, and 6 through 10 for rules that are considered less important. As your business standards change, modify rule priorities to reflect these changes.

   By default, the rule is associated with the lowest available value.

   To add, edit, or delete a priority, click the button to open the Add/Edit Priority window. For more information, see Adding Priorities and Managing Priorities.

8. To associate categories and subcategories with the rule, open the Add/Edit Category window by clicking the button too the right of the Categories section. For information about working with categories, see Associating Categories to Business Rules.
9. Construct an expression that defines the business rule. Use functions and operators to create the expression statement. See About the Expression Builder for more information. You can select either the current attribute or one of the expression shortcuts.

   The shortcuts use the syntax attribute.function, where attribute is the name of the current attribute and function is either mask, metaphone, pattern, or soundex.

10. If you are creating an ABR in the library, click Impact to view which library objects the rule will affect. For more information, see Working with Business Rules Library.
11. Click Finish.

    The new ABR displays in the ABR List View for that attribute. If necessary, analyze the rule.

12. Right-click the new rule and select Drill down to passing or Drill down to failing to see the passing and failing rows and/or values results. If you used one of the expression shortcuts, you can also drill down to see those passing or failing results; for example, passing or failing masks.