Deep Insight of Your Master Data with MDG Data Quality Analytics 2.0

[KefW]

Abstract

SAP Master Data Governance is a state-of-the-art master data management application. Data Quality Management in MDG enables you to define master data quality rules, striving for consistent usage across all points of entry and enabling data quality monitoring and remediation.

On release SAP S/4HANA 2023FSP2 and Cloud 2408, SAP Master Data Governance has delivered data quality analytics 2.0, which enables end users, from Chief Data Officer to master data specialist, a real time quality abstract, and the data quality drill down further by important segment e.g., rule attribute and important business partner/customer/suppliers/products attributes and organization unit for example Country, Plant, Sales Organization,  Company Codes etc..  

It includes mainly:

• 14 Analytics CDS views for product and business partners
• 2 Out-of-box data quality dashboards for product and business partners in SAP Analytics Cloud by leveraging these analytics CDS views.

Highlights:

Data Quality Analytics 2.0 provides Quality Score on dimensions for example, master data  attribute, organization unit etc., used in the dashboard. It gives you a clear comparison between organization units for example plant, company code etc., on same data quality standard. Each Plant, Sales Org, Region owner have clear picture of their own data quality status and ranking among all organizations. From there, they are motivated to identify a problem, dig root cause, and finally put it into action to improve data quality.  From aggregated data quality score, it is also possible to drill-down into each erroneous master data to trigger data remediation process.

Analytics CDS Views

See 7 analytics CDS views for Business Partners and 7 analytics CDS views for Product  in SAP Help Portal 

All these analytics CDS views support custom fields extensibility on business partner, customer, suppliers, and products master data. 

In S/4,  end user can open view data of analytics CDS in graphic or reporting UI using Query Browser app. Key user can also configure smart business apps for multiple end users using Manage KPI and Report app.

Query Brower - MDG Data Quality CDS ViewsQuery Browser - Customer Sales Data Quality Analysis

Understand the Quality Score

Each analytics query CDS view provides a measure Quality Score, which is calculated dynamically for your selection dimension attribute.

The Quality Score give you clear comparison between organization units e.g., plant, company code on same data quality standard.  Each Country, Plant, Sales Org, Region owner have clear picture of their own data quality status and ranking among all organizations.

Data Quality Score by Country/Region

Data Quality Dashboards 2.0 in SAP Analytics Cloud

The 2 dashboards provide a deep quality analytics for business partner(including customer and supplier)  and product master data which can quickly identify the root cause of quality problem and continuously monitoring data health to safeguard customer core business. It enables end users, from Chief Data Officer to master data specialist, a real time quality abstract, and the data quality drill down further by important segment e.g., rule attribute and important business partner/customer/suppliers/products attributes and organization unit for example Country, Plant, Sales Organization,  Company Codes etc.  

Both Dashboard contains an Overview page providing data quality score on following reporting: 

• Dimension Category 
• Dimension 
• Validation Rule 

Dashboard for Business Partner( SAP__MDG_DQ_BP_V2)  contains an Analytics page providing quality score and number of Not OK evaluation results for following data: 

• Business Partner General Data 
• Customer General Data 
• Customer Sales Data 
• Customer Company Code Data 
• Supplier General Data 
• Supplier Purchasing Data 
• Supplier Company Code Data 

Dashboard for Products( SAP__MDG_DQ_PRODUCT_V2)  contains an Analytics page providing quality score and number of Not OK evaluation results for following data: 

• Product Header data 
• Product Plant Data 
• Product Sales Data 
• Product Description 
• Product Valuation Data 
• Product Classification Data 
• Product Dimensions Data 

Both dashboards provide embedded authorization control via live data connection of analytics CDS views in MDG on S/4. And also provides integration to MDG system for data remediation seamlessly. 

SAP Analytics Cloud - Data Quality Dashboard 2.0 - BP: Overview

SAP Analytics Cloud - Data Quality Dashboard 2.0 - BP: Analysis

SAP Analytics Cloud - Data Quality Dashboard 2.0 - Product: Overview

SAP Analytics Cloud - Data Quality Dashboard 2.0 - Product: Analysis

Set Up Dashboard for Your SAC Tenant

Open Content Network from your tenant, find the SAP Master Data Governance – Data Quality Analysis package, and import it.

You can find details in my previous blog:  Get Your Master Data Quality Insight from SAP **bleep**... - SAP Community

SAP Analytics Cloud - Business Content Network

Summary

Following this blog, you should be able to

• explain what’s provided functions in MDG Data Quality Analytics 2.0.
• set up the out-of-box data quality dashboard in SAP Analytics Cloud for your end user or using S/4 embedded analytics capabilities.