Create a Domain-Based Attribute
Collapse the table of content
Expand the table of content

Create a Domain-Based Attribute (Master Data Services)


Applies To: SQL Server 2016 Preview

In Master Data Services, create a domain-based attribute to populate an attribute's values with members from an entity.


To perform this procedure:

To create a domain-based attribute

  1. In Master Data Manager, click System Administration.

  2. On the Manage Models page, click a model, and then click Entities.

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

  4. Click Attributes.

  5. On the 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.

  6. On the Add Attribute page, select the Domain-based option.

  7. In the Name box, type a name for the attribute. It does not have to be the same name as the entity that you use for the source of the attribute values.

  8. As needed, type a display name.

  9. In the Display pixel width box, type the width of the attribute column to be displayed in the Explorer grid.

  10. From the Entity list, choose the entity to be used to populate the attribute values.

  11. Optional, for domain-based attributes for leaf members. Select a filter parent attribute that is used to constrain the allowed values for the domain-based attribute.

    The filter parent attribute must be another domain-based attribute for a leaf member, within the same entity. A derived hierarchy must exist with a level that defines the parent-child relationship between the domain entities of the two attributes.

  12. Optional. 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).

  13. Click Save attribute.

  14. On the Entity Maintenance page, click Save entity.

Community Additions

© 2015 Microsoft