PerformancePoint and Master Data Management revisited
Would your company benefit from having an MDM system? That is a system that develops "...a framework of processes and technologies aimed at creating and maintaining an authoritative, reliable, sustainable accurate and secure data environment that represents a 'single version of truth,'...across a diverse set of application systems, lines of business, and user communities." see Master Data Management and Customer Data Integration for a Global Enterprise ?
A week ago I posted An intro to Master Data Management for PerformancePoint Server. I want to clarify that features, cross-application support, etc... for MDM is still in the works at Microsoft and remains somewhat hypothetical aside from what Stratature has already generously offered. What I suggest in the article is almost a self-evident suggestion for what we can expect as support for PPS.
After having read a little more literature on MDM and given it some thought, I want to provide a diagram that gives a more detailed (somewhat hypothetical) vision of what MDM means for PerformancePoint and for other data warehouse driven applications.
Before I expand a little more on what I call a self-evident suggestion for MDM->PPS support, I want to provide a simplified (and probably inaccurate) diagram that strongly builds the case for have a Master Data Management system. Enough cannot be said on the benefits and reasons for MDM - remember to read Microsoft MDM roadmap. So here is a diagram that may help folks conceptualize only one of the larger problems companies are having -that the MDM will fix. This image is derived from one of Stratature's videos.
The diagram does not demonstrate that there may be different business units that use the same systems but define the dimensions differently.
MDM-->PPS Planning diagram. Remember that this view includes detail as it relates to PerformancePoint Server Planning AND Monitoring. Also, that currently there are several disparate sources at which data integration occurs in the Business Planning Modeler, Monitoring-dashboard designer, and Proclarity BI applications.
Contribute your feedback to the diagram...you can add comments to areas of the diagram. To add comments to the diagram or draw on it, you must log in to http://itpro.conceptshare.com/dev.aspx?ws=16850 and type the username and password.
- username: ITProGuest@live.com
- password: samiam2
Note that PerformancePoint Planning and Monitoring will allow you to pull data directly from the Master Data Management system. Here is an example of how data connections are made in PPS Dashboard Designer.
Remember, MDM is a work in progress. I just wanted to give a little more detail to MDM for PPS.
