Set Up Data Quality Rules

Master Data Online (MDO) ensures quality of data through business rules. Users have the option to select predefined business rules or custom based rules to run their data against. Business rules are based on parameters like completeness, accuracy, mandatory, timeliness, transformation and consistency. The section below provides a brief overview of how MDO uses the different types of business rules to ensure Data Quality. 

Completeness

The extent to which the data is complete is termed as data completeness. It can also determine which data is missing and whether data is acceptable to be incomplete. MDO facilitates Data Quality Workbench as a platform where, it can display the percentage of completeness of each record being saved. This is important for the health check of data because it provides with consistency all the required information to be saved in the system. 

In MDO, to ensure completeness, the Metadata Rule is used to apply checks to a record based on the inherent properties of the fields involved, such as data type, length, predefined formats, etc. To apply this rule, the field(s) need to be assigned and their existing properties checked. 

For a more detailed information on how to setup a Completeness business rule, refer to the link on Metadata Rule.

Accuracy

Data accuracy is a component of data quality which verifies if the value stored for an object is correct or not. MDO performs validation on field values to check if the value that is stored for the field is correct or not. MDO provides the ease of defining the field type for data and its standard format, so if the records are not in the specified format or type, then the error is highlighted. This validation can be performed on existing records as well as during record creation.  

MDO uses Regex rules to make sure the data entered in the fields are in the format and type as expected. A Regex Rule is used to check the accuracy of a field’s value through a regular expression. A regular expression is a combination of string consisting of characters, operators, and constants to describe a search pattern or condition.  

For a step by step guide on how to apply and set up Regex Rules, refer to the link on Regex Rules.  

Mandatory 

Defining a field as mandatory through business rules ensures a value is always present for the field. The record could not be submitted unless a value is assigned to the field. Configuring a field as mandatory can be done while creating a field and selecting ‘Mandatory’ under Other Characteristics or while adding field to a layout. 

Refer to the links below on how to configure fields as mandatory. 

Adding New Fields

MDO Form Layout

Standardization

Data standardization checks for the standard of the data stored in the system. This facilitates ease in process of analysing large-scale records and provides the user with single view. Using the data quality workbench, data checks can be performed on the standard in which data is stored. MDO provides this as a platform on which users can define the set of rules on how the standard of the records need to be defined in the system for new as well as the existing records. If the records are not in the defined format they are highlighted, and if defined, can be transformed into the required format. For the new records in the system, it acts as an active governance framework.  

Refer to the section on Cleanse and Govern under Data Quality for more information on Data standardization.