Master Data Services Rules that fail will prevent all rules from running on certain rows of data

UsesOnlyOutdatedVersions 0 Reputation points
2023-05-08T21:00:45.9933333+00:00

Is there anyone out there who can provide help to me on Business Rules in Master Data Services? I'm running SQL Server 2019 Master Data Services 15.0.4312.2 and running into a problem.

I have a table like this:

NameIsNotUsedButDuplicatesCode

CodeIsARowNumberOrEntityKey

SuperThingNumber

SuperThingModifiedName

SuperThingDomainEntity

We want to manage the mapping table by just pasting a number in the SuperThingNumber column, and then Business Rules should grab that and pick the right members per row in the SuperThingDomainEntity column, which is sourced from a different table as a domain entity.

Works great as long as every number in SuperThingNumber refers to a valid row in the SuperThingDomainEntity table, but what if we want a row of mappings even for potential-future members of SuperthingDomainEntity, and then everything goes sour.

It would be fine if the Business Rules just said "well there's no domain entity for this SuperThingNumber when I look in the SuperThingDomainEntity table, so I'll just leave it blank and continue", but that's not what happens. Instead, NO RULES AT ALL will run on the rows where there's no domain member to match the SuperThingNumber.

How can I make MDS Business Rules that experience errors not cause the rest of the Business Rules to also fail on the affected rows? This seems like a M$ bug or at least lack of planning, because I also seem to have no way to make an IF statement to look and see if a domain member is there without a Custom Script, which I don't have server access to create (I'll have to ask IT SQL support at that point, even though they really don't know MDS at all).

Thank you for any response! ~Nicole the Witless

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,129 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
    2023-05-09T05:44:50.0033333+00:00

    Hi @UsesOnlyOutdatedVersions

    Thank you for your question. It looks like your problem has been solved.

    This is a document about Business Rules (Master Data Services): https://learn.microsoft.com/en-us/sql/master-data-services/business-rules-master-data-services?view=sql-server-ver16.

    Hope it helps you more.

    Best regards,

    Aniya

    0 comments No comments