Add Attributes to a Change Tracking Group (Master Data Services)

Applies to: SQL Server (all supported versions) - Windows only Azure SQL Managed Instance

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:

To add attributes to a change tracking group

  1. In Master Data Manager, click System Administration.

  2. On the Manage Model page, select a model from the grid and then click Entities.

  3. On the Manage Entity page, select the row for the entity that you want to create an attribute for.

  4. Click Attributes.

  5. On the Manage Attributes page, do one of the following.

    • If the attribute is for leaf members, select Leaf from the Member Types list box.

    • If the attribute is for consolidated members, select Consolidated from the Member Types list box.

    • If the attribute is for collections, select Collection from the Member Types list box.

  6. Select the row for the attribute you want to edit, and then click Edit.

  7. Select the Enable change tracking check box.

  8. In the Change tracking group box, type a number for the group.

  9. Click Save attribute.

    For the edited attribute, the Enable Change Tracking Group column in the grid is changed to Yes (Group: entered group number).

  10. 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.

Next Steps

See Also

Create a Text Attribute (Master Data Services)
Create a Domain-Based Attribute (Master Data Services)