Add Attributes to a Change Tracking Group (Master Data Services)
Applies To: SQL Server 2016 Preview
In Master Data Services, add attributes to a change tracking group when you want to track changes to the attribute's values.
After you add an attribute to a change tracking group, when values for the attribute change, the attribute is flagged as changed in the Master Data Services database. Create a business rule to take action based on the change.
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).
Attributes must exist to add to the change tracking group. For more information, see Create a Text Attribute (Master Data Services).
To add attributes to a change tracking group
In Master Data Services, click System Administration.
On the Model Explorer page, from the menu bar, point to Manage and click Entities.
On the Entity Maintenance page, from the Model list, select a model.
Select the row for the entity that you want to track attribute values for.
Click Edit selected entity.
On the Edit Entity page:
If the attribute is for leaf members, in the Leaf attributes pane, select the attribute and click Edit leaf attribute.
If the attribute is for consolidated members, in the Consolidated attributes pane, select the attribute and click Edit consolidated attribute.
If the attribute is for collections, in the Collection attributes pane, select the attribute and click Edit collection attribute.
Select the Enable change tracking check box.
In the Change tracking group box, type a number for the group.
Click Save attribute.
On the Entity Maintenance page, click Save entity.
Repeat this procedure for all attributes you want to include in the group. Use the same change tracking group number for each attribute in the group.