2012年3月11日 下午 08:17
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?
2012年4月30日 上午 07:56
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?
Arunjeet Singh (Microsoft SQL Server Master Data Services)
2012年5月20日 下午 03:14
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.