Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Create a Model
Collapse the table of content
Expand the table of content

Create a Model (Master Data Services)


Applies To: SQL Server 2016 Preview

In Master Data Services, create a model to contain model objects.


To perform this procedure:

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

To create a model

  1. In Master Data Services, click System Administration.

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

  3. On the Model Maintenance page, click Add model.

  4. In the Model name box, type the name of the model.

  5. (Optionally) In the Log Retention Days field, enter the number of days to retain log data. The default value is NULL, which indicates that the value is inherited from system settings in the Master Data Services Configuration Manager. For more information, see System Settings (Master Data Services).

    To override the system setting and not remove transaction log data, set this field to -1. To retain only today’s log data and truncate log data for all previous days, set the field to 0. To retain log data for a specified number of days, set the field to the number of days.

  6. Optionally, select Create entity with same name as model to create an entity with the same name as the model.

  7. Optionally, select Create explicit hierarchy with same name as model to create an explicit hierarchy with the same name as the model. This option also enables the entity for collections.

  8. Optionally, select Mandatory hierarchy (all leaf members are included to create the explicit hierarchy as a mandatory hierarchy.

    This option is disabled by default and is enabled once the previous option is selected.

  9. Click Save model.

Community Additions

© 2015 Microsoft