A rule set contains rules organized for use. When editing a rule that belongs to a rule set, you must provide a rule name and a valid rule expression. All other properties are optional.
If the rule is contained in a rule set, you can review the list of associated data sources that will be affected when you edit the rule. If needed, disassociate the rule's parent rule set from one or more data sources to limit the impact of the change.
Note: Required properties have an asterisk "*" beside their name.
To modify a rule in a rule set
-
To open an existing library rule to edit, do one of the following in the Business Rules Library:
- Go to the Rule Sets tab. Double-click the rule set that has the rule you want to modify. The Rule Set: Name panel opens. On the Rules tab, double-click the rule you want to modify.
- Click the All Library Rules tab. Run a search. From the All Library Rules tab, double-click a row.
The Library Business Rule: Name panel opens.
- Click Enabled to enable the library rule. To disable the rule, clear the selection.
- In Name, modify the library rule name. You can use an existing name as long as the name is unique to the rule set.
- For Priority, click the drop-down list and select the rule priority.
- In Description, modify the rule description.
-
For Passing Threshold, use the slider bar to modify the threshold percentage. You can also use the left/right arrow keys of your keyboard to set a new value. Alternatively, you can enter a numeric value with up to two decimal places of precision, in the text box beside the slider, such as 92.78. If you do not add an appropriate value you see the message:
Enter Percentage Value
.Note: The percentage value reflects the number of rows that should pass/fail during rule analysis. Enter 100 if all rows must comply. - In Categories, view the associated category to verify it is correct. To add or edit the associated category, see Associating Categories with Rules.
-
In Expression, modify the rule expression using functions, attributes, literals and operators. You can also define the expression manually or use the Expression Builder.
- To use the Expression Builder, click the edit icon . The Edit Expression panel opens. Open multiple instances of the Expression Builder to configure your statements.
- Define the expression statement in the text area. For attribute names that start with a zero, include the name within in single quotes, for example, '01line'. Otherwise, you will get an error.
- To check your expression, click Validate. To check your expression as you enter it, select Auto-validate. When the expression is correct, a Validation Succeeded message displays under the text area. If the expression is incorrect, a Validation Failed message displays, along with the reason for the failure. For example, unexpected identifier or unrecognized variable. Modify the expression as needed.
- Click Done to save the expression and close the Expression Builder.
To learn about the Expression Builder, see Using the Expression Builder.
- Define the Filter By, Group By, or Aggregate By expression. See Advanced Options.
- For Maximum Failing Rows Returned, click the drop-down list and select Default (10,000 rows), Custom, or Unlimited. For Custom, specify the maximum failing rows returned by typing a numeric value (the default is 16,000). For more information, see Maximum Failing Rows Returned.
-
If the rule is contained in a rule set associated with one or more data sources, click Manage Impact to view or edit associations:
-
In the Manage Impact window, select one or more data sources. Do one of the following:
- Click Disassociate to disassociate the rule set from the data sources. All rules in the rule set will be removed from the data sources. Changes you make to this rule set will no longer affect the analysis of the data sources.
- Click Disassociate - Leave a Copy to disassociate the rule set from the data sources and leave a copy of the rule(s) in the data source. The rule(s) will no longer be connected to the rule set.
- A message opens showing the impact of this change. Click either Disassociate or Disassociate - Leave a Copy.
-
In the Manage Impact window, select one or more data sources. Do one of the following:
-
Do one of the following:
- Click Save to save your changes and to keep the panel open for further modifications. If the rule is in a rule set that is associated with a data source, the Review Impact of Changes window displays. Click Manage Impact to view or change the data source associations or click Continue to save your changes.
- Click Save As to create a new rule in the associated rule set based on the current rule. If the rule is in a rule set that is associated with a data source, the Review Impact of Changes window displays. Click Manage Impact to view or edit associations, or click Continue. The Save As New Rule window opens. Enter a unique name for the rule and click Save. The new rule displays in the Library Business Rule: [Name] panel.
-
Click Done to close the Library Business Rule: Name panel. If you added a new rule, ensure the rule is listed on the Rules tab in the bottom view.