Technical Articles
MDG DQM: Empowering Your Business with High-Quality Data in S/4HANA
Hi All,
As organizations embark on the journey of digital transformation and re-discovering their business processes,at the heart of this transformation is the master data. Most of the organizations miss to capture valuable insights in their businesses due to lack of master data quality, starting from supplier records, customer records, product data etc.
INTRODUCTION
SAP already has a robust solution in the MDM space which is SAP MDG, and from S/4 HANA 1909 SAP came up with a solution of data quality management which can be integrated along with the governance of the master data. This solution will provide insights about the current data quality in the system and will help organizations cleanse their master data.
In this blog post we will look at how to create data quality quality rule for product master and run data evaluations based on this rules and see how the data quality dashboards looks like in FIORI.
MAIN CONTENT
1.At the outset we need to provide access to the role SAP_BR_PRODMASTER_STEWARD, activate the Odata services and SICF nodes to start working with the below tiles in FIORI.
Fiori group
2. Click on validation rules( products ) and create a new rule. You will have to provide the rule ID, a rule name, base table on which the rule will be applied.
Rule creation fields
3.Once the rule is created it’s status will be “NEW” and you can add usage for this rule. The usage of the rule implies whether the rule can be used in change request request processing, consolidation& mass processing and data quality evaluation. In this blog we will only look at data quality evaluation.
Rule usage
4.Once the usage is added we will prepare “USAGE ACTION”, this will create BRF+ expressions where we can write our rules
Usage action
5. There will be 2 expressions created, one is the scope expression and another will be the condition expression. The scope expression will help in selection of data for which the condition has to applied.
BRF+ expressions
6. Once expressions are created then you can send the rule for implementation which will change the status to “TO BE IMPLEMENTED”.
7. Click on the scope expression and it will navigate you to the BRF+ application. Here you can add the field which will determine the records of base table which has to be selected. In this case i considered the weight unit in MARA to be KG or G. Then click on activate to activate the expression.
Creation of scope expression
8. Click on condition expression and follow the same steps as pt6. My condition is net and gross weight should not be equal to 0.
Condition expression
9. Approve the rule, and then enable the usage for Data quality evaluation.
BC set for DQM
11. We need to create data quality scores, which can be done from the “Configure data quality scores” app. Create a global category and provide the values for target, warning and critical.
Data quality score category
12. Add rule ID, which is the rule we created above and provide a dimension(“free text”). Set the target, critical, warning values for this rule along with it’s weight and impact.
rule ID
13. Now run the data quality evaluation and see how many records satisfy the rule and how many don’t.
data quality run
final result
Reconciled with MARA( base table )
14. The data quality score is 10.9 which calculated as ( OK records/( OK + NOT OK records ) ).
Score
CONCLUSION
In this blog, we see the step by step process of creating a basic validation rule for products and how it can be used for data quality evaluation.
In future blog posts, i hope to share how to use the rules in the change request processing, mass processing and consolidation. With each release of S/4 HANA the SAP MDG DQM feature is evolving with the goal to become the single rule repository for all kinds of processes in MDM.
Hope you like this blog.
Do share your comments.
Regards
Anirban
Hi Anirban, thanks for that step-by-step description that shows how easy validation rules can be implemented. To make use of that rule implementation in change requests, mass processing or consolidation you just have to add the additional usages. No further BRFplus implemenation is needed.
More information on DQM within MDG can be found in our how-to-section.
Regards,Sabine
Hi Sabine,
Thanks for your comment, Yes the same BRF+ expressions can be used across all the usage types.
Regards
Anirban
Hi Anirban.
Thanks for the informative blog. I always follow your blogs as its very helpful for initial understanding of new topics.
I also creating a POC on DQM and used the same use case but when I am used the app "Configure data quality scores” app. My screen is completely blank , I cannot see anything as Global parameter etc. Below is screenshot for your reference. Could you please guide what could be the reason for this.
Thanks,
Mahak
Hi Srihari,
Thanks.
Could you please check the gateway logs when you open this app and see if any odata services are not activated. You can also check SU53 logs as well to see if there is an authorization issue.
Regards
Anirban
Hi Anirban,
I am trying to follow the steps you mentioned above in the screenshots and I wanted to create a POC for DQM however when I select the template and start the validation process , it gets stuck at 0% and does not process anything further. Could you help me understand how to solve this issue?
Hi Jayraj,
It's difficult to analyze what the issue might be without looking at the system or the system logs.
You can check if the SLG1 logs for your process and see if you can find something.
One thing i can suggest is you that you can check the BGRFC settings.
https://blogs.sap.com/2021/02/01/mass-processing-of-business-partners-using-mdc-in-fioripart-1/
Regards
Anirban
Dear Roy
When a press the expression in your step 7, I get the following error message:
"Navigation to this application is not supported."
I have access to the BRF+ Workbench when i open it in the Webdynpro via the back end, but cannot access it in Fiori.
Do you have any idea, what configuration I am missing out on.
Best regards, Lasse Louis
Hi Lasse,
I think there is some specific Odata service which is not active in your system.
You can check the gateway error logs and also SU53 errors to find out what is missing.
Regards
Anirban
Hello Guys,
any idea, what is the use of Allow Configuration of Additional Condition Fields in DQM Apps. We are in SAP S4 2022 version and looks like we want to add additional conditional field in BRF+ Decision table from result of other DQM Derivation rules,but system does not allows it.
Error comes like " Field should be added only using DQM App"
Regards
Samyak
Data quality evaluation Score is not reflecting on my rules or dimensions configured does anyone has a solution for this since all configuration looks correct, and data quality evaluation enabled