Create a Domain-based Attribute (MDS Add-in for Excel)
Applies To: SQL Server 2016
In the Master Data ServicesAdd-in for Excel, administrators can create a domain-based attribute when they want to constrain the values in a column to a specific set of values.
The values can already be in the worksheet or they can come from an existing entity.
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).
The model and entity must already exist.
In Excel, load the entity that contains the column (attribute) you want to constrain. For more information, see Export Data to Excel from Master Data Services.
Click any cell in the column you want to constrain.
In the Build Model group, click Attribute Properties.
In the Attribute Properties dialog box, in the Attribute type list, choose Constrained list (domain-based).
In the Populate the attribute with values from list:
To use values from the worksheet, choose the selected column. A new entity and new staging table will be created with the values from the selected column.
To use values from an existing entity, choose the name of the entity.
If you chose the selected column in the previous step, in the New entity name box, type a name for the new entity. This can be the same as the column (attribute) name.
Click OK. Each cell in the column now has a list of values for users to choose from.
- To add and delete values in the constrained list, load the entity that the attribute is based on. For more information on loading entities, see Export Data to Excel from Master Data Services.