Relational Databases for Master Data Management

Executive Summary The State of MDM at Companies. The Benefits and Challenges of Relational Databases. Using Relational Databases for MDM as well as for Transactional Data. Challenges of MDM Master data management has some very definitive challenges, and those challenges enlarge when the system must be managed in SAP. All of the SAP’s various applications…

How to Understand Master Data Management for SAP

Executive Summary What Drove an Investigation into Master Data Management Solutions. What are the Common Problems with Master Data Management Solutions? Why do Some Vendors go to Such Lengths to Prevent People from Seeing the Solutions on their Websites? What is MDM? Master data management or MDM describes the approach for maintaining the master data…

An Approach for Improving Master Data Maintenance: Better than MDM Software

Executive Summary The State of Master Data in Supply Chain Planning Systems. What Approach has Tended to Work Versus those that Have not Worked? Why There are So Many Opportunities to Improve Master Data in Supply Chain Planning Systems. Introduction The state of master data concerning supply chain planning systems offers a continual opportunity for…

Synchronizing the Supply Chain Calendars Between the Planning and ERP Systems

Executive Summary Why is Synchronization of these Calendars Important? What Does a Calendar Represent to a Planning or Execution System? Introduction There are frequent issues of accuracy on projects on the various calendars in planning systems and ERP systems.  A calendar is a constraint on activity—standard calendars include the factory and the shipment calendar. However,…

Using MAPILab to Enable Searchable Application Parameter Spreadsheets

Executive Summary What is MAPILab? How Does It Assist in Searching Through Large Excel documents? Why are Spreadsheets so Important for Sharing Master Data Parameters in Supply Chain Planning Systems? How is MAPILab used to Improve the searchability of spreadsheets? Introduction Spreadsheets are very handy for keeping all of the parameter data of an application….

A Methodology for Adjusting Master Data

Executive Summary Does MDM Have to be as Complicated as it Often Presented? Why so Many MDM Projects Approach the Problem from the Wrong Perspective. What is the Real Process for Practical Master Data Maintenance? Introduction There are very significant opportunities to improve master data in supply chain organizations. After years of talking about master data…

Understanding Master Data Management Using Excel and PowerPivot

Executive Summary Master data management can be performed with Excel and PowerPivot. The common problem that some applications have with regards to master data maintenance. Introduction to Master Data Management I work with some best-of-breed solutions all across supply chain planning. Almost all of these applications have master data interfaces that take the effort to…

How Distributed PLM functionality in Planning Systems Differs from BOM Management

Executive Summary Why is PLM such a confusing subject for many people? What is the status of master data generally, and what are its needs? What is the imbalance between the ability to create versus update master data? Why is ERP often confused with BOM management software? How does confusion among the different terms and…

Why Demand Works is a Model for Configuration Data Management

Executive Summary What application in supply chain planning is a model of simplicity concerning its master data? How does Demand Works Smoothie work concerning master data maintenance? What is the imbalance between the ability to create versus update master data? Introduction In this article, we described the serious configuration management issues with SAP SCM. In…