Change the Attribute Type (MDS Add-in for Excel)
Applies To: SQL Server 2016
In the Master Data ServicesAdd-in for Excel, administrators can change the attribute type when the data type or number of allowed characters is incorrect.
If you want to change the attribute type to create a constrained list (domain-based attribute), see Create a Domain-based Attribute (MDS Add-in for Excel).
To perform this procedure:
You must have permission to access the System Administration and Explorer functional areas.
You must be a model administrator. For more information, see Administrators (Master Data Services).
There must be an existing model, entity, and attribute.
In Excel, load the entity that contains the column (attribute) you want to change. For more information, see Export Data to Excel from Master Data Services.
Click any cell in the column you want to change.
In the Build Model group, click Attribute Properties.
In the Attribute Properties dialog box, update settings as needed.
If there is any dependency on the attribute, such as the attribute is referenced by any MDS business rule or derived hierarchy, you cannot change the data type of the attribute. You get an error stating that the attribute type cannot be modified because it is referenced by an object.
If there is any error during data type conversion for the attribute values, MDS does the following.
Changes the data type of the attribute.
Generates a copy of the attribute with the suffix “_old” that contains the previous values. This is called a deprecated attribute.