Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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
Former Member replied

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.


Dola Aich

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

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question