There is an issue with MDS 2012 and business rules with a combination of “must be unique” attributes. If you do not list the attributes in the same order that they were created you will get a generic error message when trying to re validate your data.
The work around for this is to recreate the “must be unique” combination of attributes in the same order as the attributes shown in the leaf attributes list. The screenshots below provide an example of the issue and solution.
In the first screenshot below we have a unique constraint containing Customer Type and Order Type. In this scenario we wanted to add Brand to the uniqueness constraint.
We can drag and drop “Brand” from our entity specific attribute list onto our combination, save, and publish the updated business rules without problem.
Once the new rules have been published a question mark will appears next to all rows of data for the entity that the business rule covers.
When we click on apply rules to re-run the business rules and validate the data we get the following error message.
As mentioned above the work around is to recreate the unique constraint with the attributes in the same order as they appear in the Entity Specific attribute lists.
In our example that means recreating the unique constraint so that Brand appears above Customer Type and Order Type.
Once the re-ordered rule has been published, applying it to the entity will work without error once more.
Part 1 – Introduction to Geospatial data
Geospatial data is a niche area that is increasingly becoming utilised in the data analytics
Jan
Logic Apps: Saving files sent via Emails into Blob Storage
Using Microsoft Logic Apps we save files to Azure Blob storage that are sent to
Jan
Create and setup B2B Integration Account in Azure
An integration account allows you to build Logic Apps with enterprise B2B capabilities by adding
Jan
Time to move to the cloud? What to expect when migrating to Azure
Moving to the cloud can be complex. Here’s a simple breakdown you need to know
Dec
Serverless Transformation Data Pipelines with Serverless SQL Pools
What are Serverless SQL Pools? Serverless SQL Pools or SQL on-demand is a serverless distributed
Dec
Basic structure of x12 Edi message
All EDI transactions get defined by EDI message standards. It is vital to have proper
Dec
MultiVendor Cloud Security with the Microsoft Stack
Over Last few years there has been a large rise in identity based attacks and
Nov
Azure Logic Apps B2B EDI integration capabilities
One of the standard and most commonly used suites of protocols for B2B data transfer
Nov