Skip to Content

This blog summarizes an ASUG webcast from Mark Hicks (mark.hicks@sap.com) and Amanda Harris (amanda.harris@sap.com).

Background

SAP has made a number of acquisitions in recent years. To help deal with this wealth of acquisition data and maintain timely delivery, the group established a Standardization and Matching program (SAM). This program uses SAP Data Services, SAP HANA, and SAP Information Steward.

DGO_acquisitions.png

The business purpose of the program is to provide a single matching tool with good quality results, for use across multiple technical platforms and business processes. One tool. The team wanted to standardize and automate data verification and matching against reference records (or within a submission) to avoid duplicate creation.

The team needed to build a fast and repeatable process and avoid unnecessary costs. These costs were determined across multiple dimensions:

  • Impact on customer satisfaction (both positive and negative)
  • Cleansing of a duplicate accounts costs between 1-4 hours of manual work and once in the Financial process might not be reversible at all.
  • Financial loss/risk, for example invoices not paid due to addressing issues and credit exposure (across multiple “customers”)
  • Sales pipeline, where the potential for upsell and avoiding conflict between sales channels must be managed

The process

The Data Migration Quality Process was identified.

/wp-content/uploads/2013/10/dgo_dm_process_299983.png

With the larger process in the place, the group focused on the specific matching method that needed to support the process. The process uses SAP Data Services as part of the SAM project.

/wp-content/uploads/2013/10/dgo_match_300050.png

For example, this is the how the approach worked on the SuccessFactors data. Notice the distinct funnel nature of the process. Where the team started with 715,000 records the potential customer accounts were reduced to 83,000.

/wp-content/uploads/2013/10/dgo_sxf_299982.png

Notice the sheer number of applications that use the routines developed as a part of SAM.

/wp-content/uploads/2013/10/dgo_sam_apps_300052.png

Results

The results of this program are amazing. In fact, the SAP Data Governance Organization won two awards this year: the Nucleus ROI Award and a TDWI Best Practices award. Check out this blog for more details on how the metrics were calculated.

If you have further questions on this SAM process, please contact Mark Hicks (mark.hicks@sap.com) or Amanda Harris (amanda.harris@sap.com).

Related blogs on SAP’s Data Governance program:

SAP’s Internal Information Governance Program: Business Value Metrics Framework

Information Governance Maturity Models: Quick and Easy

Using the Program Management Office to help your initiative

OneSAP for Data Quality

Information Governance Tips + Tricks from a Practitioner

Creating a data culture in your company: What you should know about Information Governance you learned in pre-school

Walking the Walk: SAP and Information Governance

Information Steward 4.2 in Practice: How SAP’s Data Management Organization Uses Information Steward

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply