Add Multiple Conditions to a Business Rule

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.

System_CAPS_noteNote

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.

Prerequisites

To perform this procedure:

To add multiple conditions to a business rule

  1. In Master Data Manager, click System Administration.

  2. From the menu bar, point to Manage and click Business Rules.

  3. On the Business Rules/ page, from the Model drop-down list, select a model.

  4. From the Entity drop-down list, select an entity.

  5. From the Member Types drop-down list, select a type of member.

  6. Click the row for the business rule you want to edit.

  7. Click Edit.

  8. Under the If block, on the left side from the logical operator drop-down list select AND/OR/ NOT.

  9. Click Add. A panel will be displayed.

  10. From the Attribute drop-down list, select an attribute.

  11. From the Operator drop-down list, select a condition.

  12. Complete any required fields.

  13. Click Save. A new row will be added to the If grid.

  14. Optionally, to add more conditions, complete steps 8-13.

    System_CAPS_tipTip

    To delete a condition, select the condition and right-click on it and click Delete.

    System_CAPS_tipTip

    You can select multiple conditions and right-click to group them inside a logical operator, or to ungroup conditions inside a specific logical operator.

Community Additions

ADD
Show:
© 2016 Microsoft