Create and Publish a Business Rule

Create and Publish a Business Rule (Master Data Services)

 

Applies To: SQL Server 2016 Preview

In Master Data Services, create a business rule to ensure the accuracy of your master data. After you create a rule, you must publish it before you can apply it to data.

Prerequisites

To perform this procedure:

To create and publish 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 Rule 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 for the business rule to apply to.

  6. Click Add.

  7. In the Name box, type a name for the business rule.

  8. Optionally, in the Description field, type the business rule description.

  9. Optionally, check the Send Notifications option and from the drop-down list select a user or group to send the email notification to.

    System_CAPS_noteNote

    Notifications are sent only for rules that include a validation action.

  10. Under the If block, click Add. A panel will be displayed.

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

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

  13. Complete any required fields.

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

    System_CAPS_tipTip

    You can delete items from your business rule by right-clicking each item and choosing Delete.

  15. Optionally, add multiple conditions to the rule. For more information, see Add Multiple Conditions to a Business Rule (Master Data Services).

  16. Under the Then block, click Add . A panel will be displayed.

  17. From the Attributedrop-down list, select an attribute.

  18. From the Operator drop-down list, select an action.

  19. Complete any required fields.

  20. Click Save. A new row will be added to the Then grid.

  21. Optionally, to add Else action, complete the following steps.

    1. Under the Else block, click Add. A panel will be displayed.

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

    3. From the Operator drop-down list, select an action.

    4. Complete any required fields.

    5. Click Save. A new row will be added to the Else grid.

  22. Click Save. A new row will be added to the business rules grid.

  23. Click Publish All.

  24. On the confirmation dialog box, click OK. The value in the Business Rule State column is Active.

For each created business rule, a row with six columns is added to the grid. The following are the columns.

Name

Description

Status

When you click Save the following image is displayed that indicates that the business rule is updating.

mds_BR_refresh

If there are errors when creating or editing a business rule, the following image is displayed.

mds_br_error

If the status is OK, then the following image is displayed.

mds_BR_success

Name

The business rule name.

Description

The business rule description.

Business Rule State

One of the following business rule statuses: : Rule not defined, Active, Excluded, Pending Changes, Pending Exclusion and Pending Deletion.

Excluded

Specifies whether the business rule is excluded.

Notification

Specifies the selected user or group to send the email notification to.

Community Additions

ADD
Show:
© 2016 Microsoft