Continuously Assuring and Controlling Master Data Quality (Part One)

Continuously Assuring and Controlling Master Data Quality (Part One)

The Business Case for Continuous Data Quality Assurance

Continuous Data Quality Assurance for enterprise-critical data is indispensable for companies striving for sustained enterprise performance: Flawless business execution and trusted cross-company analyses depend on the quality of the underlying master data, and the challenge of continuously assuring premium master data quality as an ongoing activity is even higher when enterprises are operated on the basis of diversified system landscapes. Tackling this challenge is key to make the competitive edge.


The Situation Today


However today, it is still common that organizations have little, or no transparency at all into what the relevant data entities for a given business process are, nor do they have comprehensive capabilities to define and control required quality KPIs for these data entities. In such a setting, the negative impact of poor master data quality is only revealed when the damage is already done, i.e., through broken business transactions and shaky company analyses that produce wrong decisions. As long as organizations cannot statistically measure the quality of enterprise-critical data and their compliance with company terms, they are in a poor position when it comes to safeguarding and improving the overall performance.

The Way to Continuous Data Quality Assurance


To tackle the situation and accommodate this high-priority need, SAP features a comprehensive and sustained way to manage the data quality. Using this data quality approach, companies can:
  • Define the relevant metrics and set up the required quality rules that their critical enterprise master data need to comply
  • Subsequently monitor the compliance statistically and clearly visualize the prevailing data quality, and
  • Trigger follow-up actions if master data reveals quality issues.
These key activities are integrated into a collaborative end-to-end process that empowers data stewards and data administrators to exercise overall data control.
Using such an approach, companies can establish a closed quality loop around their enterprise master data management strategy.
image
Fig: SAP BusinessObjects Data Services and Xcelsius dashboards clearly visualize the prevailing data quality and trends. Defined quality dimensions can comprise (to name just a few):
  • Completeness (e.g., all mandatory fields contain data)
  • Conformity (e.g., all formats must match given patterns)
  • Validity (e.g., data must be in a valid range)

This data quality scorecard and remediation solution brings data, systems, and people together into one collaborative and coherent process flow. It combines SAP NetWeaver Master Data Management, SAP BusinessObjects Data Services and Xcelsius dashboards into a cohesive monitoring environment, and flexibly integrates with SAP NetWeaver Business Process Management to seamlessly trigger follow-up action if the data quality revealed forces to do so.  It is a perfect means to bring companies in good shape and keep them there on an ongoing basis.
Sounds interesting? Then stay tuned for part two of this blog series which will focus on architectural and implementation considerations of this scenario.

 

Benefit Now From Support Package 4 for SAP NetWeaver MDM 7.1

Benefit Now From Support Package 4 for SAP NetWeaver MDM 7.1

Enhancements for Governed Master Data Creation and Maintenance Processes in Conjunction with SAP NetWeaver BPM

When it comes to collaboratively governed master data creation and maintenance processes in heterogeneous landscapes, SAP NetWeaver BPM together with SAP NetWeaver MDM provide the perfect environment for setting up end-to-end data governance workflows that span across several systems.
By combining SAP NetWeaver BPM and SAP NetWeaver MDM in such contexts, companies can flexibly define data creation and maintenance processes where a new master data record (for example, a customer or a supplier record) can be requested, checked, approved and finally created in a coherent process flow that includes required automated and manual tasks and associated roles.
image
As of SAP NetWeaver MDM 7.1 SP04, SAP NetWeaver BPM can directly consume specific MDM data governance UIs that can be used for human interactions (e.g. data steward enriching master data information) and specific MDM Web Services for fully automated steps (e.g. validation runs) in the overall workflow.
In this context, SAP NetWeaver MDM 7.1 SP 04 provides the following enhancements:
  • Data Governance UIs based on WebDynpro technology: Using the MDM Web Dynpro Configurator which is a wizard-based tool that exposes MDM repository metadata you can configure MDM Web Dynpro Components without coding. Using this wizard, you can easily set up Web Dynpro UI components for Search, Result Set, and Item Details that can be directly consumed by BPM.
  • MDM Web Services: To further increase MDM openness and process automation there are additional Web Services available whose functional scope goes beyond basic CRUD operations. For example, there are new Web Services to run MDM validations, check-out records, launch MDM workflows and get and update key mapping information.

A Look at the Underlying Architecture

image
From an architectural perspective, such a scenario consists of different layers.
First, there is the process layer, in which a logical process is composed by defining an end-to-end workflow that involves automated steps and human interactions. The automated steps are based on WebService calls to the respective data foundation which consists of SAP NetWeaver MDM, SAP BusinessObjects Data Services, and any other WebService enabled backend-system. For human interactions, you have the user interface layer, for which you compose specific UIs based on WebDynpro technology that can be directly integrated with and consumed by SAP NetWeaver BPM.

Major data foundation components in this sample process are:
  • SAP NetWeaver MDM as the overarching master data instance that can be called in the process, for example, via specific UIs for human process activities (such as data enrichment by a data steward), or via Web Servces for automated process steps (e.g. specific validations)
  • SAP BusinessObjects Data Services as underlying data quality engine that can be called via WebService calls, for example, for address or name cleansing prior to the data creation.
Process steps such as data creation approvals can be accessed through the portal-based Universal Worklist (UWL).

Note:

For in-depth information about how to set up such an end-to-end process using SAP NetWeaver BPM and SAP NetWeaver MDM, SDN features a comprehensive eLearning material.
Check out the recorded deep-dive session that focuses on the new MDM Web Dynpro UI components and Web Services including their deployment, configuration and integration in the process modeling using SAP NetWeaver BPM.
For an overview of the end-to-end process and the business benefits of such a scenario, watch this animated demo.

For an up-to-date picture of the overall functional scope of SAP NetWeaver MDM 7.1, see the overview presentation.

 

What’s New in NetWeaver SAP MDM 7.1 Publisher

Publications Bookmark

This new feature, released in MDM 7.1 sp04, enables publications management in a hierarchy bookmark structure.

Before this feature, the publications list was flat and un-sortable. With a large number of publications it was difficult to manage.

Now, in Publisher the publication tree drop down control will have a hierarchical structure (also seen in the File->Open dialog) with up to 3 root nodes: Personal Bookmarks, Global Bookmarks, All Publications.
Bookmarks can be organized via Main Menu 'File->Organize Publication Bookmarks'. A dialog is invoked
which allows the user to define hierarchy beneath the bookmark root nodes as well as dragging in
publications from the 'All Publications'. This dialog exposes right click menus as well as F2, Del, and drag
and drop functionality.

A new Console role function is introduced 'Functions->Publications->Modify Global Publication Bookmarks' to control write privileges to Global Publication Bookmarks (true by default). Please note that write privileges to 'Personal Bookmarks' are always allowed for an mdm user.


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 

3

 



 


 


 

Image Links Palette Pane

This new feature, released in MDM 7.1 sp04, enables showing the properties of the family records referenced images.

Before this feature the image properties were not accessible from Publisher.

Select from Main Menu View->Panes->Image Links to view the Image links palette.


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 

4

 



 


 


 

Publisher Command Line Options to Launch Directly to Target

This new feature, released in MDM 7.1 sp04, allows launching a Publication or Family Hierarchy directly from a desktop shortcut.

From main menu select File->Send To->Desktop (create shortcut). This command will create a shortcut on
the desktop and populate the command line parameters according to the current selection state that the
publisher is in when the menu is invoked. The shortcut will be named according to the publication and
perspective.

If a user wants to open Publisher (which previously would load the Family Hierarchy as a starting point),
open a publication and then select a node and spread; there is now a direct action that saves time.


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 

5

 



 


 

Add Records to a Family by Drag and Drop from Data Manger to Publisher

This new feature extents the ability to manage the records of a family.

Before this feature, adding a new record to a family was done by adding a new record associated with the same family and refreshing the presentation Hierarchy in Publisher.

Now, it is possible to drag and drop a record from Data Manager to Publisher and add it to a family, even if it is not associated with that family.

To do that, open Data Manager on Records pane and drag a record onto the Publisher Record Tab. The record dragged will be added to the familys records.


 


 


 


 


 


 


 


 


 


 


 


 


 

Drag and
Drop


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 

6

 



 


 


 

Copy/Paste Overridden Node Properties

This new feature allows copying a nodes overridden (not inherited from the root) properties and applying (pasting) it to another node.

Before the feature it was only possible to either inherit node properties from parent or to propagate properties from parent node.

Now, it is possible to copy paste node properties between nodes even if they are not from the same branch. In the Presentation Hierarchy, Right click from a node and select "Copy overridden node properties". Select the destination node, right click and select "Paste overridden node properties". You may select which
properties to apply.


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 

 



 


 


 

Free Form Styling of Texts on Spread

This new feature allows extended styling capabilities by applying text style from the spread.

Before this feature, it was possible to modify an items style from the Item Properties tab based on preset
styles.

Now, it is possible to change an items text style (and change only part of the texts style) from the spread
itself. The style can be set from the spread it self and does not need to be predefined as a style.
In the Spread Pane, double click on the text you wish to modify and apply the style in the Formatting dialog.


 

Note: A recalculation of the Presentation Objects will reset the styles.


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


8

 


 


 


 


 

Recordset Publication

This new feature enables creating a publication structure based of hierarchies linked to the main table records.

Before this feature it was possible to create either an Empty Publication or a Family Publication (based on the taxonomy table and further partitioning of it).

Now, creating a Recordset Publication allows the specification of any hierarchy field in the main table to base the structure to be created upon.

Also, any collection of masks can be used to prune down this structure to only the relevant nodes. The result is a pruned down hierarchy with leafs of record set publication nodes.

Select from Main Menu File-> New to create a new publication, select Recordset Publication from the dropdown publication type and select which Hierarchy to base the publication on from the Organize By dropdown list. Select Masks for pruning the publication, if needed.


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 


 

9

 


 


 


 

MDM Publishing API and MDM Publishing Demo Web Portal

With MDM 7.1 the MDM publishing solution has been extended with Publishing Java API (PJA) and Publishing Web Portal (PWP) set of code examples.

The interface provided through PJA is currently a subset of what can be done through the Publisher

Application. The detailed technical description of the interface is provided in the form of "javadoc in the SAP MDM installation package.

The Publishing API enables creating a custom interface of a "lean" publisher, generate and display publication through the web by an organization and external users.


 


 

Related Content

MDM Publisher Reference Guide

How to Create Publications with SAP NetWeaver MDM Using MDM Publisher

HowtoCreatePublicationswithSAPNetWeaverMDMUsingMDMPublisher-AdvancedTopics

Best Practices for SAP NetWeaver MDM Taxonomy

For more information, visit the Master Data Management homepage.

10

 


 


 


 


 


 

Master Data Management Webinar - Part 4

Master Data Management Webinar - Part 3

Master Data Management Webinar - Part 2

Master Data Management Webinar - Part 1

What is Master Data Management?

SAP Master Data Management - Governed Customer Data Creation

Downloads for Master Data Management - SAP MDM

Downloads for Master Data Management


         


Since preconfigured business content of SAP NetWeaver MDM has proven to be successful, we further extend this approach by introducing MDM Quick Starters. MDM Quick Starters (QS) are preconfigured business packages that are intended to enable SAP NetWeaver Master Data Management (MDM) customers to rapidly deploy and implement a working scenario for master data management processes on top of MDM and in some cases, in conjunction with SAP NetWeaver Business Process Management (BPM).


This content quick starter package facilitates a fast implementation of a Physician Spend Aggregation process leveraging SAP NetWeaver MDM. It covers the data extraction from SAP Business Suite systems as well as the actual import into SAP NetWeaver MDM. Once the data has been consolidated it is ready for usage by reporting tools such as SAP NetWeaver BW. Life sciences companies can directly leverage the out-of-the-box integration content limiting the time to value to a minimum.09 May 2010
 
 

Tool
This quick starter package provides the relevant content for a Collaborative Creation Process for Material Master Data based on SAP NetWeaver MDM and BPM. It serves as a starting point and can be easily tailored to specific business needs.09 May 2010
 
for More information visit






MDM Workflow Launch Problem version SAP MDM 7.1.2.59


heck the SAP Note 1300651 - Workflow table is disabled - MDM Data Manager

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1300651
In MDM Data Manager, make sure the Workflows table is the current table. In the Records pane, select any workflow record.
In the Record Detail tab, then double-click on the Workflow property to open Microsoft Visio. Choose Tools > Options from the Visio main menu.Choose File Paths to open the File Paths dialog. In the File Paths dialog, set both Add-Ons and Start-Up to the folder where the Worklfow.vsl file is installed (the Data Manager installation folder, by default). Click OK to close the File Paths dialog.

also go through the links below for similar issue

for MS visio version
http://forums.sdn.sap.com/thread.jspa?messageID=8213783#8213783

http://forums.sdn.sap.com/thread.jspa?messageID=6203237#6203237

http://forums.sdn.sap.com/thread.jspa?messageID=9608778#9608778

http://forums.sdn.sap.com/thread.jspa?messageID=2020392#2020392

SAP MDM Tutorial Sample Data.zip

Hi Xi_ted below are the links which will hwlp you to understand MDM scenarios and the efrence guide links also present.http://www.asug.com/DesktopModules/Bring2mind/DMX/Download.aspx?TabId=66&DMXModule=370&Command=Core_Download&EntryId=3431&PortalId=0

MDm
http://www.asug.com/DesktopModules/Bring2mind/DMX/Download.aspx?TabId=66&DMXModule=370&Command=Core_Download&EntryId=1666&PortalId=0

SAP Netweaver MDM Overview
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b09b548d-7316-2a10-1fbb-894c838d8079

SAP NETWEAVER MDM Leverage MDM in ERP Environments - An Evolutionary Approach -
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/4059f477-7316-2a10-5fa1-88417f98ca93

Master Data Management architecture patterns
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0703sauter/

MDM and Enterprise SOA
http://www.saplounge.be/Files/media/pdf/Lagae---MDM-and-Enterprise-SOA2007.10.10.pdf

Effective Hierarchy Management Using SAP NetWeaver MDM for Retail
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ee0c9e-29a8-2910-8d93-ad34ec8af09b

MDM World
http://mdm.sitacorp.com/

MDM: Master Data for Global business
http://www.sitacorp.com/mdm.html

MDM Master Data Management Hub Architecture
http://blogs.msdn.com/rogerwolterblog/archive/2007/01/02/mdm-master-data-management-hub-architecture.aspx

Improve Efficiency and Data Governance with SAP NetWeaver MDM
http://www.sapnetweavermagazine.com/archive/Volume_03_(2007)/Issue_02_(Spring)/v3i2a12.cfm?session=

Data Modeling i MDM
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d4211fa-0301-0010-9fb1-ef1fd91719b6

http://www.sap.info/public/INT/int/index/Category-28943c61b1e60d84b-int/0/articlesVersions-31279471c9758576df

SRM-MDM Catalog
http://help.sap.com/saphelp_srmmdm10/helpdata/en/44/ec6f42f6e341aae10000000a114a6b/frameset.htm


http://events.techtarget.com/mdm-ent/?Offer=DMwn716mdm

http://viewer.bitpipe.com/viewer/viewDocument.do?accessId=6721869

http://searchdatamanagement.bitpipe.com/data/search?site=sdmgt&cr=bpres&cg=VENDOR&sp=site_abbrev%Asdmgt&cp=bpres&st=1&qt=Master+Data+Management

http://viewer.bitpipe.com/viewer/viewDocument.do?accessId=6721819

http://www.dmreview.com/channels/master_data_management.html

http://searchdatamanagement.techtarget.com/originalContent/0,289142,sid91_gci1287620,00.html?bucket=NEWS&topic=307330


MDM Console -- http://help.sap.com/saphelp_mdmgds55/helpdata/en/88/9f9c427055c66ae10000000a155106/frameset.htm

MDM Import manager --http://help.sap.com/saphelp_mdmgds55/helpdata/en/43/120367f94c3e92e10000000a1553f6/frameset.htm

MDM DataManager --http://help.sap.com/saphelp_mdmgds55/helpdata/en/43/e0615a82b40a2ee10000000a11466f/frameset.htm

MDM Syndicator --http://help.sap.com/saphelp_mdmgds55/helpdata/EN/43/5fe0e8a55f5f6be10000000a1553f6/frameset.htm

MDM library link

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_library&query=MDM+&adv=false&sortby=cm_rnd_rankvalue&start=21

SAP MDM Console 7.1 Reference Guide:

MDM Workflow - Exclude a user in a step


For More Help 

We are in SAP MDM 7.1 SP04.

1. Start - Process - Approve -- Stop
2. Start - Check out record
3. Stop - Check In Record.
4. Process Step owner - Launcher of the Workflow.
5. Approve Step assigned to a Role.
6. 2 roles - Requestor and Approver.
7 User A has both Roles Requestor and Approver.

Q: Requestor(User A) launches the workflow - while sending from Process to Approve Step - we have to ensure that the owner of process tep in the workflow should not be able to approve the record -- Is it possible to check and exclude or show an error message that the previous owner is not allowed to be selected in the Approve step.
so my another question to you is

what is the assignee type and authorizations are provided to this User or Roles ?

are you assigning the same roles to both this users ? What is the Execution type for this Workflow? try to make it as All Sequential Orderd and then see if it works if it does not then please let me know we will check out some other way for this/
 

Message Flow from MDM to PI:

Message Flow from MDM to PI:
MDM JCA Adapter catches the syndication event and uses the MDM Port functions to retrieve the data.
It is important to understand that only MDSS is able to throw the syndication event.
A manual syndication using the Syndicator does not throw this event, I mean that MDM 7.1 PI Adapter is unable to pick the XML message coming from the manual syndication.
So here i assume that every file picked from MDM port is syndicated using MDSS only in your case. If it is not there i mean manual syndication too then PI will not pick this file. So for automated operation Syndication services should be always running.
lly for PI to MDM, Event is thown by MDIS and caught by MDM JCA Adapter.

Also, Check you need to deploy the JAVA API for MDM Adapter. The MDM-Adapter is not started until you deploy the JAVA API. You can check the status of the Adapter in the NWA -> Start & Stop Application -> Search for "MDM".
Make sure that the MDM Java API (Connector) deployed on the J2EE engine matches the version of the MDM server on which the repository is mounted.


Hope it helps...

More info


SAP Developer Network Latest Updates