PeopleSoft EPM Warehouses and Reporting

The PeopleSoft EPM warehouses provide you with the tools and technology to manage your organization's information that is used for reporting and analysis. Each warehouse is divided into multiple subject areas, or data marts. Each data mart is aligned with a business process, which enables you to answer strategic questions essential to your organization's bottom line.

Image: EPM Warehouses

The following graphic illustrates how the EPM warehouses fit into the overall EPM architecture.

PeopleSoft provides the following EPM warehouses:

Campus Solutions Warehouse
Customer Relationship Management (CRM) Warehouse
Financials Management Solution (FMS) Warehouse
Financials Warehouse for Public Sector and Higher Education
Human Capital Management (HCM) Warehouse
Supply Chain Management (SCM) Warehouse

Prepackaged Content

PeopleSoft delivers the following content with each EPM warehouse:

Extract Transform and Load (ETL) component
Infrastructure tables and tools
Security tables
Staging tables
Multidimensional Warehouse tables
Data Models
Measures

Reporting tables are built in the MDW to enable offloading of operational reports from your transactional systems. As part of your implementation, you need to consider which operational reports it makes sense to offload to the EPM warehouses.

The EPM warehouse documentation (such as the PeopleSoft EPM: Campus Solutions Warehouse) provides more details on the each of the EPM warehouses.