How can we check if a Domain based attributes being referenced by another Entity

Question

Hi,

I want to delete records in reference data domain based entity "brand" in MDS but before that I want to delete all records in "Product" where brand is used. How can I do this?

Thanks

Rehan

Answer 1

Hi Rehan

Bring up the Product entity in the Explorer or the Excel Add-in and filter to see all records where the Attribute that refers to the Brand entity is non-null. You can then either edit all the records that have a value and set it to empty (the Excel Add-in is probably a better way to do this because it allows batch edits) or just remove the records (whatever you prefer).

Does that answer your question?

Arun

---

Arunjeet Singh (Microsoft SQL Server Master Data Services)

Answer 2

Thanks Arun,

That's probably the easiest way to do this. We are also moving to SQL Server 2012 and we can make use of the Excel Add-in now. With SQL Server 2008 R2 this was not very straight forward.

Thanks again,

Rehan