You can modify the elements of a library business rule at any time. Use the Save As option to create a new library rule based on the current rule. 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: To modify multiple library rules at a time, see Modifying Multiple Library Rules.
To edit a library rule-
Do one of the following in the Business Rules Library:
- Click All Library Rules and double-click a library rule.
- Click Rule Sets and double-click a rule set. On the Rules tab, double-click a rule.
The rule's edit 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.
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 to Rules.
- 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. For more information, see Maximum Failing Rows Returned.
-
In Expression, modify the rule expression using functions, attributes,
literals, and operators. You can 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 if needed 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 expressions using instructions in Advanced Options.
-
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 message 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 message 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.
- Continue editing the rule or click Done.
-
(Optional) To open the rule set that contains the rule, click the rule set's name
above the rule's name. In the following example, click Boston data to open the
rule set that contains the rule Boston data, no CC info.