Prerequisites

After you have configured IBM WebSphere DataStage for EPM, and before you run CRM 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 CRM 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 Unit Setup, Using the Master Sequencer Utility to Create Master Sequencer Jobs.

See Understanding the EPM Lineage Spreadsheets.