MDM Data Manager step-by-step process with an example

[Former Member]

Hi All,

I recently started reading MDM. I am clear with MDM-Console concepts. But I have problem with MDM Data Manager. I am confused with data entries in qualified tables, work flows(using microsoft studio), Matching mode- rules(High treshold, low threshold) etc.. I read material posted in forums- but still I am not clear.

I need a step-by-step process for data entries with *examples*. A good example which covers all Data Manager concepts. PDF's with screen shots, videos any thing would help.

Please help me......It would be of great help.

Thanks in Advance.

Suchir

[Former Member · Accepted solution]

Hey Suchir,

Check these links it might be helpful

http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0615f82b40a2ee10000000a11466f/frameset.htm

http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0677c82b40a2ee10000000a11466f/frameset.htm

and also refer:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c01f54a2-99f1-2a10-5aa5-dcc50870... (PDF IMPORTING)

/people/michael.reil/blog/2006/05/18/mdm-matching-strategies-for-master-data-consolidation (matching merging in mdm)

http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0615f82b40a2ee10000000a11466f/frameset.htm

/people/klaus.david/blog/2005/09/16/mdm-validations(validations)

Regards

SR

[Former Member]

Hey Simona, Shilpa,

Thanks for the reply. I tried to go through the links which you refered, but I am not able to open/access them. So, it was not that helpful. Please can you please tell me if there is any other way to acess these links.

Simona, its for you I really do appreciate the way you answer or deal with a problem step by step. How can I master the subject like you.

Thanks

Suchir.

[Former Member]

Hi Suchir,

Humbly, Thank you for your appreciation

All the links that I have provided are opening at my end.You should be able to view them as I do.

However if you are not able to view the links in my previous post .You can have a look at the below additional helpful links:

MDM Overview:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/801b0fcf-e880-2b10-5398-aedec8cf... (MDM Overview)

Qualified Table:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a15239-684e-2b10-b8ae-b936b7d1... (Qualified Imoprting)

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/301494b6-4bbe-2a10-8a8b-ae45dc34... (Qualified syndication)

Workflows:

https://www.sdn.sap.com/irj/scn/wiki?path=/display/mdm/violation%252bof%252brole%252bpermissions%252...

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60f28084-b90e-2b10-3eb6-d6565367...

Matching Mode:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80fc0a2e-6561-2910-839e-8ff3e36d... (data modelling)

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/909108b0-64a1-2910-c39d-bcd63a01...

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/408b8031-6fc4-2b10-c18b-a77abefb... (Optimized matching in MDM)

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0028dc3-9ff1-2a10-408b-a8d42f50...

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi Suchir,

If you are able to access the links and your Query has been resolved.

Kindly mark the thread as answered and close it.

So that others will similar query can access it later.

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi Suchir ,

MDM 5.5 has 4 MDM clients to perform 4 main functionality on the MDM master records.

- Console- This is where all the Administrative work is performed

- Data Manager- This is where the actual maintainence work is done on the master data like consolidation deduplication etc.

- Import manager- Thsi is from where the source matser records are taken into MDM repoistory

- Syndicator- This is from where teh consolidated master data is send back to the target systems.

MDM Data Manager is the heart of MDM

The activities that can be performed in the MDM Data manager are:

- Data Consolidation

- Data Validation

- Data Deduplication

- Data Assignment

- Data Governanace

etc......

Qualified Table:

- Qulaified tables are used to store relational records where one field value is determining the other field or fields value.

- Qualified tables are maintained in Console and can be viewed in Data Manager

- Qualified Table are viewed under a separate section in Data Manager in the right hand side.

- Qualified table has Non qualifiers and Qualifiers.

- Non qualifiers can be seen in the Qualified table and in the linking Qualified field

- Qualifiers can be seen separately under the Qualified section in the data manager

Kindly refer the below link to know more on this:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a15239-684e-2b10-b8ae-b936b7d1...

Workflows

- Workflows are designed in MDM for Governanace

- You can create the MDM workflow using the MS Visio 2003 stencils in the MDM Data manager in the record mode under the workflow table

- The saved workflow in DM can then be executed either mnaully or automatically based on teh trigger actions

- The trigger action for teh MDM wf are record Add,Update,Import,Manual

Kindly refer the below link to know more on this:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60559952-ff62-2910-49a5-b4fb8e94... (MDM Workflows Overview)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90990743-91c0-2a10-fd8f-fad371c7... (Demo of MDM Workflows)

Matching Mode

- This mode is exclusively for Master data deduplication

- We need to create Rules,Strategies,Transformation in MDM data manager in teh record mode

- Then you need to run these strategies on the selected records

- Based on your score and threshold set in the strategy MDM will identify duplicate records

- This score will be seen in teh Matching mode

- Colour coding is used along with scores to find out dupliactes

- Green - 100%dupliacte Blue- 50?% Red- No duplicate

Kindly refer the below link to know more on this:

/people/michael.reil/blog/2006/05/18/mdm-matching-strategies-for-master-data-consolidation (matching merging in mdm)

Hope It Helped

Thanks & Regards

Simona Pinto