Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Automatically Generate Code Attribute Values (Master Data Services)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

In Master Data Services, automatically generate values for an entity’s Code attribute when you want an integer to be automatically assigned to the Code value each time a new member is created.

To perform this procedure:

To automatically generate Code values

  1. In Master Data Services, click System Administration.

  2. On the Model Explorer 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 generate codes for.

  5. Click Edit selected entity.

  6. Select the Create Code values automatically check box.

  7. In the Start with box, type a number to begin incrementing. If members already exist, the Code will be set based on the highest existing value. For example, if the highest existing Code value is 299, the next member’s Code value will be set to 300.

  8. Click Save entity.

Community Additions

ADD
Show:
© 2015 Microsoft