September 21, 2023 09:46 by
Peter
Statement of the Problem
A business rule in Master Data Services is a rule that you employ to ensure the quality and accuracy of your master data.
Is it feasible to create a business rule that ensures a constant length of value within an attribute?
Unfortunately, there is no direct feature/condition/operator to accomplish this request; however, it can be handled by combining various features/conditions/operators.
Solution
Navigate to Administrative Tasks on the Master Data Service (MDS) site. Click on Manage >> Business Rules
Provide the Name and Description for the Business rule and Click on the Add section within Then
Select the Attribute ( one column ) and Operator as Must have a minimum length of
Post that provides the intended length value and Click Add. Finally, Click on Save.
Similarly, Add one with a Maximum length validation rule, which would finally result in the below aspect.
Click on Save to Create the Business Rule.
The Business Rule would be in Activation Pending State.
Output
The length of the value is 5.
Length of value is other than 5
a) Length < 5
b) Length > 5
HostForLIFE.eu SQL Server 2019 Hosting
HostForLIFE.eu is European Windows Hosting Provider which focuses on Windows Platform only. We deliver on-demand hosting solutions including Shared hosting, Reseller Hosting, Cloud Hosting, Dedicated Servers, and IT as a Service for companies of all sizes.