Hi masters , Actually maintain the master data in BI also then why the spec

[Former Member]

HI masters ,

Actually maintaing the master data also we can do in BI, then why we have to need MDM.

What is special purpose with mdm. please tell brefily,

[Former Member · Accepted solution]

Hi Surya,

In MDM we maintain only master data

The goal of MDM to make master data unique and accurate.

BI is used to analyze data from diverse source to support decision making. In BI transaction data are placed in a table named Fact table .This fact table or transaction data are connected to master data /dimension table using some foreign key. Example of different transactions data are :- Quantity sold, sales revenue .In BI /BW we can analyze transaction data i.e. we can calculate total quantity sold for a particular region .

There may be different sales representative for different region. And every sales representative have different and unique ID.

To calculate total quantity sold we have to do the following things

We have to select sales representative Id of the specified region.

Based on sales representative Id (which is master data) for a particular region and the summarized quantity sold by them we can get the total quantity sold for a particular region.

So this master data sales representative Id should be correct and unique based on which we will analyze transaction data otherwise the result would be wrong.

These sales representative ID is maintained in MDM.

Basic scenarios of MDM are

1) Consolidation

2) Harmonization

3) Central master data management

MDM assures following things

u2022 Accuracy - Does my data adhere to defined formats and standards?

u2022 Validity - Does my data contain incorrect information?

u2022 Completeness - Does my data contain all the necessary information?

u2022 Consistency - Does my data contain contradicting or duplicate information?

SAP Master Data Management (SAP MDM) is a component of SAPu2019s Net Weaver product group and is used as a platform to consolidate, cleanse and synchronize a single version of the truth for master data within a heterogeneous application landscape.

Thanks

Dola Aich

Edited by: DOLA AICH on Oct 14, 2008 10:34 AM

[Former Member]

Hi Surya,

Please mark this as answered if u feel your question has been answered.

or For further quaries you can ask question.

Thanks

Dola Aich

[Former Member]

Hi Surya,

BI or say BW are analytical reporting tools whereas MDM is used for master data management.

Business Intelligence systems are designed to help organizations understand their operations, customers, finance etc. This information is used to make decisions about organizational direction. Poor reports results in poor decision making. The costs can be enormous.

The basic reason the reporting is wrong is that the operational data feeding the analytical engines is filled with errors, duplications and inconsistencies. If the poor quality reporting is to be fixed, it has to be fixed at its source u2013 poor quality data under the applications that run the business. This is the Master Data. The solution to this overarching problem is Master Data Management. MDM is the glue that ties analytical systems to what is actually happening on the operational side of the business.

Basic Need of MDM

1. Consolidation of Master Data

2. Harmonizarion of Master Data

3. Central Master Data Managment

MDM can be used for scenarios like

1. Rich Product-Content Management

2. Global Data Synchronisation

3. Customer Data Integration

For more help, you can refer to the below link.

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

Hope it helps.

Thanks,

Minaz

[Former Member]

Hi surya,

MDM Provide many advantages like

1. Deduplication - Identifying duplicate records and merge them which leads to efficient reporting in BI. This is one of the major advantage of using MDM.

2. Validations & Assignments - We can validate the records to ensure consistency i.e. avoiding incorrect master records.

3. Ability to Import data from different systems at same time.

There are many more...

Please check the below link as well

Regards,

Jitesh Talreja

Edited by: Jitesh Talreja on Oct 14, 2008 1:26 PM

[former_member198313]

Hi Surya,

Adding to Jitesh, MDM is not for master data maintain it is master data management.

MDM is requires for master data similar to BI is required for reporting even when we can have reports from r/3 or other systems also.

Hope this helps,

+ An

[Former Member]

Hi Surya,

Please check the below link(An's document ) which explains how MDM is helpful when used with BI

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6009e125-e9a3-2a10-c6a9-e1483dfa...

Regards,

Jitesh Talreja