Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Create an Entity

Create an Entity (Master Data Services)


Applies To: SQL Server 2016 Preview

In Master Data Services, create an entity to contain members and their attributes.


To perform this procedure:

To create an entity

  1. In Master Data Services, 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. Click Add entity.

  5. In the Entity name box, type the name of the entity.

  6. Optionally, in the Name for staging tables box, type a name for the staging table.

    If you do not complete this field, the entity name is used.


    Use the model name as part of the staging table name, for example Modelname_Entityname. This makes the tables easier to find in the database. For more information about the staging tables, see Importing Data (Master Data Services).

  7. Optional. Select the Create Code values automatically check box. For more information, see Automatic Code Creation (Master Data Services).

  8. Optional. Reset the Data Compression option. By default the row compression is turned on. For more information , see Data Compression.

  9. From the Enable explicit hierarchies and collections list, select one of the following options:

    • No. Select this option if you do not need to enable the entity for explicit hierarchies and collections. You can change this later if needed.

    • Yes. Select this option when you want to enable the entity for explicit hierarchies and collections. In the Explicit hierarchy name box, type a name. Optionally, select Mandatory hierarchy (all leaf members are included to make the explicit hierarchy a mandatory hierarchy.

  10. Click Save entity.

Community Additions

© 2015 Microsoft