create-a-numeric-attribute-master-data-services.md

title	Create a Numeric Attribute (Master Data Services) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	master-data-services
ms.topic	conceptual
helpviewer_keywords	attributes [Master Data Services], creating number attributes creating number attributes [Master Data Services]
ms.assetid	c0dbb6d8-ba78-485a-a40d-6d5cb7e75d0a
author	lrtoyou1223
ms.author	lle
manager	craigg

Create a Numeric Attribute (Master Data Services)

In [!INCLUDEssMDSshort], create a numeric attribute when you want users to enter a number as an attribute value.

Note

Numeric attributes have limitations. For more information, see Attributes (Master Data Services).

Prerequisites

To perform this procedure:

• You must have permission to access the System Administration functional area.

• You must be a model administrator. For more information, see Administrators (Master Data Services).

• An entity must exist to create the attribute for. For more information, see Create an Entity (Master Data Services).

To create a numeric attribute

1. In [!INCLUDEssMDSmdm], click System Administration.

2. On the Model View page, from the menu bar, point to Manage and click Entities.

3. On the Entity Maintenance page, from the Model list, select a model.

4. Select the row for the entity that you want to create an attribute for.

5. Click Edit selected entity.

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

7. On the Add Attribute page, select the Free-form option.

8. 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).

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

10. From the Data type list, select Number.

11. In the Decimals box, type the number of numbers that can be entered after a decimal.

12. From the Input mask list, select a format for negative numbers.

13. Optionally, select Enable change tracking to track changes to groups of attributes. See Add Attributes to a Change Tracking Group (Master Data Services) for more information.

14. Click Save attribute.

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

See Also

Attributes (Master Data Services)
Change an Attribute Name (Master Data Services)
Create a Domain-Based Attribute (Master Data Services)
Create a File Attribute (Master Data Services)