| title | Add Attributes to Change Tracking Group | |||
|---|---|---|---|---|
| description | Add Attributes to a Change Tracking Group (Master Data Services) | |||
| author | meetdeepak | |||
| ms.author | dkhare | |||
| ms.reviewer | mikeray | |||
| ms.date | 03/05/2026 | |||
| ms.service | sql | |||
| ms.subservice | master-data-services | |||
| ms.topic | how-to | |||
| ms.custom |
|
|||
| helpviewer_keywords |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
[!INCLUDE support-notice]
In [!INCLUDEssMDSshort], add attributes to a change tracking group when you want to track changes to the attribute's values.
Note
After you add an attribute to a change tracking group, when values for the attribute change, the attribute is flagged as changed in the [!INCLUDEssMDSshort] 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).
-
In [!INCLUDEssMDSmdm], click System Administration.
-
On the Manage Model page, select a model from the grid and then click Entities.
-
On the Manage Entity page, select the row for the entity that you want to create an attribute for.
-
Click Attributes.
-
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.
-
-
Select the row for the attribute you want to edit, and then click Edit.
-
Select the Enable change tracking check box.
-
In the Change tracking group box, type a number for the group.
-
Click Save attribute.
For the edited attribute, the Enable Change Tracking Group column in the grid is changed to Yes (Group: entered group number).
-
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.
Create a Text Attribute (Master Data Services)
Create a Domain-Based Attribute (Master Data Services)