Add Multiple Conditions to a Business Rule (Master Data Services)
Applies To: SQL Server 2016 Preview
In Master Data Services, add multiple AND or OR conditions to a business rule when you want a more complex rule.
If you create a business rule that uses the OR operator, consider creating a separate rule for each conditional statement that can be evaluated independently. You can then exclude rules as needed, providing more flexibility and easier troubleshooting.
To perform this procedure:
You must have permission to access the System Administration functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
A business rule must exist. For more information, see Create and Publish a Business Rule (Master Data Services).
To add multiple conditions to a business rule
In Master Data Services, click System Administration.
From the menu bar, point to Manage and click Business Rules.
On the Business Rule Maintenance page, from the Model list, select a model.
From the Entity list, select an entity.
From the Member Type list, select a type of member.
From the Attribute list, select an attribute or leave the default of All.
Click the row for the business rule you want to edit.
Click Edit selected business rule.
In the Components pane, expand the Logical Operators node.
Click AND or OR and drag it to the IF pane's AND label.
In the Components pane, expand the Conditions node.
Click a condition and drag it to IF pane, to the AND or OR label from step 10.
In the Attributes pane, click an attribute and drag it to the Edit Condition pane's Select attribute label.
In the Edit Condition pane, complete any required fields.
In the Edit Condition pane, click Save item.
Optionally, to add more conditions, from the Components pane, drag AND or OR to any AND or OR in the IF pane. Then follow steps 13-15.
To delete a condition, click the name of the condition and in the Edit Condition pane, click Delete item.