Export (0) Print
Expand All

Create an Entity (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, 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.

    Tip Tip

    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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft