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.


Discover the latest in Master Data Management.

Related Articles

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

A Guide to Selecting the Right Financial Planning and Analysis Solution

From Features to Functionality and Cost: A Comprehensive Guide to Selecting the Right Financial Planning and Analysis Solution You might have heard of Anaplan, Board, Workday Adaptive Planning, TM1, IBM Planning Analytics, Oracle and Planful. These are tools that aid Financial Planning and Analysis (FP&A). They have the potential to elevate your financial planning, budgeting,

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