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 Manager, click System Administration.
From the menu bar, point to Manage and click Business Rules.
On the Business Rules/ page, from the Model drop-down list, select a model.
From the Entity drop-down list, select an entity.
From the Member Types drop-down list, select a type of member.
Click the row for the business rule you want to edit.
Under the If block, on the left side from the logical operator drop-down list select AND/OR/ NOT.
Click Add. A panel will be displayed.
From the Attribute drop-down list, select an attribute.
From the Operator drop-down list, select a condition.
Complete any required fields.
Click Save. A new row will be added to the If grid.
Optionally, to add more conditions, complete steps 8-13.
To delete a condition, select the condition and right-click on it and click Delete.
You can select multiple conditions and right-click to group them inside a logical operator, or to ungroup conditions inside a specific logical operator.