In this monthly release, we added a few highly asked features. Please give it try and look forward to hearing your feedback.

Manage Business Rules (MDS Add-in for Excel)

In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).

Many-to-Many Relationships in Derived Hierarchies

You can now create a Derived Hierarchy that displays many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.

For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.

You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query performance. For more information, see Custom Index (Master Data Services).

A member revision history is recorded when a member is changed. You can rollback a revision history, as well as view and annotate revisions. Using the Log Retention Days property, you can specify how long historical data is retained. For more information, see Member Revision History (Master Data Services).

This release includes a number of performance improvements – most users will see a 4x improvement when loading data from an MDS server, without any additional server or environment changes. For an additional performance increase (2-4x), you can enable Dynamic Content Compression in IIS.

It works with both SQL12 or SQL14. The installation will be in place upgrade so the users don't need to uninstall previous installation. All the MDS connections will be preserved through the installation.

Please download the new version of Excel add-in. Your feedback is welcome!

While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer." Please select this button when a reply answers your question.

There are several reasons to do this:

Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.

You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)

You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.

I have SQL Server 2016 SP1, Master data Services, and Data Quality Services installed on same server. I upgraded SQL Server to SP2. After that Master Data Services web application stopped working and ...

I am configuring a new Master Data Services 2017 site. I want to have 2 models on my site - one for test/dev work and one for Live data. I created my test model (let's call it MyModel_TEST) and added ...

I have applied a unique index to the Name attribute on an entity. When I try to add a new member as a SuperUser with a duplicate Name value I get an informative error message that there is a unique ...

In this monthly release, we added a few highly asked features. Please give it try and look forward to hearing your feedback.

Manage Business Rules (MDS Add-in for Excel)

In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).

Many-to-Many Relationships in Derived Hierarchies

You can now create a Derived Hierarchy that displays many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.

For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.

You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query performance. For more information, see Custom Index (Master Data Services).

A member revision history is recorded when a member is changed. You can rollback a revision history, as well as view and annotate revisions. Using the Log Retention Days property, you can specify how long historical data is retained. For more information, see Member Revision History (Master Data Services).

This release includes a number of performance improvements – most users will see a 4x improvement when loading data from an MDS server, without any additional server or environment changes. For an additional performance increase (2-4x), you can enable Dynamic Content Compression in IIS.

It works with both SQL12 or SQL14. The installation will be in place upgrade so the users don't need to uninstall previous installation. All the MDS connections will be preserved through the installation.

Please download the new version of Excel add-in. Your feedback is welcome!

While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer." Please select this button when a reply answers your question.

There are several reasons to do this:

Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.

You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)

You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.