Create a Text Attribute (Master Data Services)
Applies To: SQL Server 2016 Preview
In Master Data Services, create a text attribute when you want users to enter a text string as an attribute value.
To perform this procedure:
To create a text attribute
In Master Data Services, click System Administration.
On the Model View 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 create an attribute for.
Click Edit selected entity.
On the Edit Entity page:
If the attribute is for leaf members, in the Leaf member attributes pane, click Add leaf attribute.
If the attribute is for consolidated members, in the Consolidated member attributes pane, click Add consolidated attribute.
If the attribute is for collections, in the Collection attributes pane, click Add collection attribute.
On the Add Attribute page, select the Free-form option.
In the Name box, type a name for the attribute. For a list of words that should not be used as attribute names, see Reserved Words (Master Data Services).
As needed, type a display name.
In the Display pixel width box, type the width of the attribute column to be displayed in the Explorer grid.
From the Data type list, select Text.
In the Length box, type the maximum number of characters allowed.
Optionally, select Enable change tracking to track changes to groups of attributes. For more information, see Add Attributes to a Change Tracking Group (Master Data Services).
Click Save attribute.
On the Entity Maintenance page, click Save entity.