Initiate Actions Based on Attribute Value Changes (Master Data Services)
Applies To: SQL Server 2016 Preview
In Master Data Services, create a business rule to initiate actions based on changes to attribute values. For example, when a specific attribute value changes, you may want to change a value, send a notification, or start an external workflow.
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).
Your attributes must be in a change tracking group. See Add Attributes to a Change Tracking Group (Master Data Services) for more information.
To create a business rule to initiate actions based on attribute value changes
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 for the business rule to apply to.
From the Attribute list, select an attribute or leave the default of All.
Click Add business rule.
Click Edit selected business rule.
In the Components pane, expand the Conditions node.
Under the Value comparison node, drag has changed to the IF pane's Conditions label.
In the Edit Condition pane, in the Change tracking group box, type the number of the change tracking group that you assigned as part of the prerequisites.
In the Edit Condition pane, click Save item.
In the Components pane, expand the Actions node.
Click an action and drag it to the THEN pane's Action label.
In the Attributes pane, click an attribute and drag it to the Edit Action pane's Select attribute label.
In the Edit Action pane, complete any required fields.
In the Edit Action pane, click Save item.
Optionally, on the Business Rules Maintenance page, for the row that contains your business rule, double-click a cell in the Name, Description, or Notification column to update the value.
Notifications are sent only for rules that include a validation action.
Click Publish business rules.
On the confirmation dialog box, click OK. The rule's status changes to Active.
Apply business rules to data by following one of these procedures: