Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

PeopleSoft EPM

Posted by Dylan Wan on November 1, 2007

PeopleSoft Enterprise Performance Management was the pre-packaged BI applications for PeopleSoft application.  It has been in market for nearly 10 year.  I recently learned its history, product coverage and architecture from my colleagues.

It mainly has two major categories – Applications and Data Warehouse.   Applications include Planning and Budgeting apps, Global Consolidations apps, and Scorecard.  These apps are similar to the offering from Oracle Hyperion I guess.  The warehouse part uses a similar architecture like today’s Oracle BI Applications.

They use the term 3M to describe the Pre-packaged Content.  I found this quite interesting.  3Ms include

  • Maps: ETL mapping
  • Models: Warehouse Star Schema
  • Metrics: Prepackaged  reporting metadata

This can be applied to Oracle BI Applications as well.

The covered area are similar to Oracle BI Applications as well:  Financials, HCM, Supply Chain, and  CRM.  Only unique warehouse schema is its Campus Solution.

One of the major problem in the past is that it lacks its own front end tool.  It does not have a consistent BI tool strategy.  It started with shipping some Cognos cubes.  It then later provided pre-packaged repository in BO and Microstratgey.  After PeopleSoft is part of Oracle, it also provided the Discoverer EUL and Oracle BI Enterprise Edition based dashboards and reports.

Like Oracle BI Applications, it used Informatica as its ETL tool , but now it uses Ascential.


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s