Prerequisites
After you have configured IBM WebSphere DataStage for EPM, and before you run Campus Solutions 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 Campus Solutions Warehouse.
Run the Dimension Mapper setup jobs.
Run shared lookup jobs.
Run the Common Dimensions jobs.
Configure the DATA_VALIDATION_SETUP and HANDLEDELETES_SETUP parameter files per your requirements (for data validation and source delete ETL jobs).
For more information about these prerequisites, see:
PeopleSoft Enterprise Performance Management Fundamentals.
Understanding Source System Deletes and the Source-Delete Diagnostic Staging Jobs
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.