Skip to Content
avatar image
Former Member

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 14, 2008 at 08:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 05:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 14, 2008 at 07:47 AM

    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

    integration-of-bi-with-master-data-management-55

    Regards,

    Jitesh Talreja

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 14, 2008 at 09:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded