Master Data Management: Problem deleting an entity in Master Data Services

Microsoft’s Master Data Services (MDS) prevents an entity being deleted if business rules have been defined for any of its attributes.

However, when trying to delete the entity in the SQL Server 2008 R2 edition of MDS, a visual indication that a business rule exists is not provided. This can be frustrating during the development of a new model as it is refined and entities are being created/deleted.

For example:
A Product entity exists within the Products model which only has the default attributes of Code and Name.
Entity 1

A business rule has then been defined for the ‘Name’ attribute to make it required.
Entity 2

Then, if the administrator tries to delete the entity and clicks ‘Ok’ to the confirmation dialogue, MDS appears to only do a screen refresh.

Entity 3

The administrator needs to first delete the rule and then re-attempt to delete the entity.
Entity 4

Related Articles

Two people working on a project using a laptop: Profisee is a master data management software

QMetrix Expands Partnership with Profisee® to Become Value Added Reseller of the Profisee Platform®

ATLANTA, GA—November 6, 2018— Profisee, a leading data management technology company that makes it easy and affordable for any size organisation to ensure a trusted data foundation, announced today it is expanding its partnership with QMetrix, an Australian leading provider of enterprise budgeting & forecasting, business intelligence, analytics and data management solutions. The partnership enables

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content