Skip to content

create-a-domain-based-attribute-mds-add-in-for-excel.md

Latest commit

 

History

History
60 lines (39 loc) · 2.89 KB

create-a-domain-based-attribute-mds-add-in-for-excel.md

File metadata and controls

60 lines (39 loc) · 2.89 KB
title Create a Domain-based Attribute (MDS Add-in for Excel) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology master-data-services
ms.topic conceptual
ms.assetid 7b3e30dc-8f41-4a5d-8009-ae5a4426a64b
author lrtoyou1223
ms.author lle
manager craigg

Create a Domain-based Attribute (MDS Add-in for Excel)

In the [!INCLUDEssMDSshort][!INCLUDEssMDSXLS], 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.

Note

If users type a value in the constrained column, rather than selecting from the list, errors are displayed in the $InputStatus$ column when they publish.

Prerequisites

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.

To perform this procedure:

  1. In Excel, load the entity that contains the column (attribute) you want to constrain. For more information, see Load Data from MDS into Excel.

  2. Click any cell in the column you want to constrain.

  3. In the Build Model group, click Attribute Properties.

  4. In the Attribute Properties dialog box, in the Attribute type list, choose Constrained list (domain-based).

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

  6. 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.

  7. Click OK. Each cell in the column now has a list of values for users to choose from.

Next Steps

  • 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 Load Data from MDS into Excel.

See Also

Domain-Based Attributes (Master Data Services)
Create an Entity (MDS Add-in for Excel)
Building a Model (MDS Add-in for Excel)