Prerequisites

After you have configured IBM WebSphere DataStage for EPM, and before you run SCM Warehouse implementation jobs, you must:

Import all of the appropriate *.dsx files containing your ETL jobs.
Compile all jobs.
Run hashed file setup jobs.
Run initial OWS setup jobs to bring source data into the SCM Warehouse.
Run the Dimension Mapper setup jobs.
Run shared lookup jobs.
Run the Setup - OWE jobs.
Run the Common Dimensions jobs.

For more information about these prerequisites, see the PeopleSoft Enterprise Performance Management Fundamentals 9.1 Documentation

Also note that because the following IBM WebSphere DataStage folders contain implementation jobs for all EPM warehouses, you must identify which jobs relate to your warehouse and, optionally, delete any unwanted jobs.

OWS
GLOBAL_DIMENSION
LOCAL_DIMENSION
Global_D00
OWE_E

You can also create your own master sequencer job, which you can use to drag and drop only those jobs relating to your warehouse and then run the master sequencer; or you can use the master sequencer utility to automate this activity. The delivered ETL lineage spreadsheet can help you identify which jobs apply to the EPM product you purchased.

See , Understanding ETL in EPM Verifying ETL Components Have Imported Properly Understanding Warehouse Business Units, TableSet Sharing, and SetID Mapping, Using the Master Sequencer Utility to Create Master Sequencer Jobs.

See .Understanding the EPM Lineage Spreadsheets

Note: For detailed information about delivered SCM Warehouse jobs and the order in which you should run them, please see the Using the ETL Lineage Spreadsheets .section.