Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
saikatjay
Participant

Introduction

In the vast world of data management, SAP Master Data Governance has established itself as a leading platform, providing a unified framework to handle, control, and govern master data. One of the essential elements in SAP MDG is Rule Mining, a feature that has transformed the way businesses manage their data.
It enables companies to expose patterns and relationships in data and real-time decision-making abilities across different data domains—whether material, customer & supplier. This blog will shed light on the concept of Rule Mining for Business Partners in SAP MDG and explain how to set up the same.

What is Rule Mining in SAP MDG?

Rule Mining is a data mining technique used in SAP MDG to discover and manage business rules. It helps identify data patterns and correlations that could help improve the overall business strategy. Turned into actionable rules, these patterns can yield practical, usable results that drive business efficiency.

saikatjay_0-1707483156768.png

Picture Source - https://www.sap.com/documents/2019/11/feac7e38-757d-0010-87a3-c30de2ffd8ff.html


Configuring Rule Mining in SAP Master Data Governance (Business Partners)
Below are the Fiori applications that we need to start working with Rule Mining for Business Partners.

App NameApp IDPurposeBusiness Roles
Manage Rule Mining for Business PartnersF4084Create and Start Mining Runs to Discover Business Rules from the existing Master Data RecordsSAP_BR_BUPA_MASTER_STEWARD

Process Rules from Rule Mining for Business Partners

F4070Review and Manage Rules from Rule-Mining RunsSAP_BR_BUPA_MASTER_STEWARD

saikatjay_1-1707484357797.png

Step 1: Activation of ICF nodes (TCODE SICF)

  • /sap/bc/ui5_ui5/sap/md_qmndrl_s1
  • /sap/bc/ui5_ui5/sap/md_qrlmng_s1

saikatjay_2-1707485725917.png

saikatjay_3-1707485762895.png

Step 2: Activation of ODATA services (TCODE /IWFND/MAINT_SERVICE)

  • CMD_QLTY_RULE_MINING_SRV
  • CMD_QLTY_MINED_RULE_SRV

saikatjay_5-1707486348937.png

saikatjay_6-1707486392260.png

Step 3: Adding Authorization (TCODE PFCG)
Create a custom role copying role SAP_BR_BUPA_MASTER_STEWARD and add below authorizations objects.

Authorization ObjectDescription
MDC_DQEVALData Quality Evaluation Permissions
MDQRM_RULEMaster Data Quality: Validation Rule
MDQRM_RLUSMaster Data Quality: Validation Rule Usage
MDQRM_MNNGMaster Data Quality: Rule Mining
MDQRM_MNDRMaster Data Quality: Mined Rule
MDQRM_RLIMMaster Data Quality: Validation Rule Import
MDQRM_RLEXMaster Data Quality: Validation Rule Export

saikatjay_0-1707487755711.png

Step 4: Adding the Apps in Fiori
Choose the apps from the business catalog SAP_CMD_BC_QLTY_EVAL_BUPA and design your Fiori page accordingly using the apps Manage Launchpad Spaces & Manage Launchpad Pages (Business role: SAP_FLP_ADMIN).

saikatjay_1-1707488427601.png

Assignment of Page and Roles in a space

saikatjay_2-1707488461210.png

saikatjay_3-1707488538592.png

saikatjay_4-1707488560566.png

Assignment of Apps in the page
saikatjay_5-1707488587182.png

Executing Rule Mining in SAP Master Data Governance (Business Partners)

Example Scenario - As a master data steward you'd like to create a mining run and to find the business rules associated with Customer General Data stored in table KNA1. 

Step 1: Use App Manage Rule Mining app to create and execute a Mining Run

saikatjay_6-1707489407057.png

Click on Create

saikatjay_7-1707489512438.png

Enter Description 

saikatjay_9-1707489875244.png

Add Tables for Mining Rule - In our case - KNA1

saikatjay_10-1707489943897.png

Add filters - If you want to find the business rules for some specific customer account groups

saikatjay_12-1707490087155.png

Add Fields - Considering we need to find out how the languages are stored for the countries in Customer Master.

saikatjay_13-1707490183178.pngChecked by Rule: Check this flag if you want this field to be checked as part of a rule. Mined rules are formatted as IF/THEN statements, selecting this flag means that this field will be in the THEN part of the rule.
Condition of rule: Check this flag if you want the field to be a condition of a rule. Mined rules are formatted as IF/THEN statements, selecting this flag means that this field will be in the IF part of the rule.

Click on Apply

saikatjay_14-1707490362821.png

Click on Start

saikatjay_15-1707490450255.png

Once the execution is complete, we can see the number of rules that are found by the ML algorithm for the above condition.

saikatjay_17-1707490603977.png

Step 2: Use App Process Rules from Rule Mining app to review the Mining Run and implement the Rules

saikatjay_18-1707490762557.png

Below are the rules found by the Mining Run 
Absolutely fascinating to see that the system is proposing us the rules which we can approve/reject and link into a validation rule which can be utilized in Central Governance

saikatjay_20-1707490987463.png

To implement a Rule, select it and click on Accept

saikatjay_24-1707491560642.png

 

Link the same to a New Validation Rule

saikatjay_25-1707491609941.png

saikatjay_26-1707491677751.png

Navigate to the Validation Rule by Clicking on the Link

saikatjay_27-1707491759514.png

The rule can be added to Change Request Process, Consolidation, Quality Evaluation & Mass Processing.
For this instance, let's add it for change request process and quality evaluation.

saikatjay_28-1707491923360.png

Click on Prepare in the Usage Option and approve the rule.

saikatjay_29-1707492013093.png

saikatjay_30-1707492075291.png

Enable the Usage in Data Quality Evaluation and Check in Change Request

saikatjay_31-1707492130970.png

Step 3: Testing the Rule

Change Request Process
Pre-requisite: Validation Rules (Data Quality) should be marked as relevant in the Change Request Step

saikatjay_32-1707492392781.png

Rule is successfully implemented in Change Request Process
saikatjay_33-1707492919640.png


Data Quality Evaluation

saikatjay_34-1707493297093.png

saikatjay_35-1707493404944.png

 

Conclusion

Rule Mining in SAP MDG is a powerful tool for driving efficiency and value in your data management initiatives. It plays a crucial role in identifying patterns and insights that could significantly improve business processes and strategies. With a proper understanding of this function and know-how to set up this system, businesses can fully leverage the potential of their master data for more informed, data-driven decision-making.

Important Links & Blogs
Using MDG Rule Mining to Improve Data Quality - SAP Community

How Machine Learning Helps Identify Data Quality R... - SAP Community

How machine learning helps to identify data quality rules with SAP MDG on SAP S/4HANA

Labels in this area