Running Campus Solutions Warehouse Implementation Jobs

This chapter discusses how to run the jobs required to implement the Campus Solutions Warehouse.

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

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 Setup - OWE jobs.

• Run the Common Dimensions jobs.

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

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 Preparing to Load Source Data Into EPM, Running Initial Setup Jobs, Importing Source Business Units into EPM to Create Warehouse Business Units, Using the Master Sequencer Utility to Create Master Sequencer Jobs.

See Using the PeopleSoft EPM Lineage Spreadsheets.

Running Campus Solutions Warehouse Implementation Jobs

This section discusses how to run all the ETL implementation jobs for the Campus Solutions Warehouse, in the following order:

1. Campus Solutions Warehouse - OWS jobs.

2. Global dimension jobs for Campus Solutions Warehouse.

3. Local dimension jobs for Campus Solutions Warehouse.

4. Campus Solutions Warehouse - SKU jobs.

Running Campus Solutions Warehouse - OWS Jobs

The first step in implementing the Campus Solutions Warehouse is to run the Campus Solutions Warehouse - OWS jobs. These jobs consist of Campus Solutions Warehouse-specific hash file jobs and OWS jobs. Run the hash file jobs first, as the tables that they load are required to run your standard OWS jobs.

As with most prepackaged jobs, you can use the Master Run Utility to automatically run a set of jobs located in a flat file on the IBM WebSphere DataStage Server. When you use the Master Run Utility, it reads a list of jobs that are present in a specified flat file and triggers the jobs to run in serial mode, using the dependency logic specified in the Input flat file.

Campus Solutions Warehouse - OWS Hash File Jobs

Perform the following steps to run the Campus Solutions Warehouse - OWS hash file jobs:

1. In IBM WebSphere DataStage Director, navigate to the hash file jobs by expanding the nodes in the left navigation panel using the following path: CS_E, OWS, Base, Load_Hash_Files, Server.

2. Select each CS Warehouse - OWS hash file job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Campus Solutions Warehouse - OWS Jobs

Perform the following steps to run the Campus Solutions Warehouse - OWS jobs:

1. In IBM WebSphere DataStage Director, navigate to the CS Warehouse - OWS jobs by expanding the nodes in the left navigation panel using the following path: CS_E, OWS, Base, Load_Tables, Sequence.

2. Select each CS Warehouse - OWS job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Running Global Dimension Jobs for Campus Solutions Warehouse

The second step in implementing the Campus Solutions Warehouse is to run the global dimension jobs for Campus Solutions Warehouse. These jobs consist of global dimension hash file jobs and global dimension jobs. Run the hash file jobs first, as the tables that they load are required to run your standard global dimension jobs.

Note. You can run global dimension jobs individually or together using the master sequence job.

Global Dimension Hash File Jobs

Perform the following steps to run the global dimension hash file jobs individually:

1. In IBM WebSphere DataStage Director, navigate to the global dimension hash file jobs by expanding the nodes in the left navigation panel using the following path: Global_Dimensions_E, OWS_To_MDW, Base, Load_Hash_Files, Server.

2. Select each global dimension hash file job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time, and the job's status is updated to Running.

Perform the following steps to run the global dimension hash file jobs together using the master sequence job:

1. In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: Global_Dimensions_E, Master_Sequence.

2. Select the global dimension master sequence job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time, and the job's status is updated to Running.

Global Dimension Jobs

Perform the following steps to run the global dimension jobs individually:

1. In IBM WebSphere DataStage Director, navigate to the global dimension hash file jobs by expanding the nodes in the left navigation panel using the following path: Global_Dimensions_E, OWS_To_MDW, Base, Load_Hash_Files, Sequence.

2. Select a global dimension job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time, and the job's status is updated to Running.

Perform the following steps to run the global dimension jobs together using the master sequence job:

1. In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: Global_Dimensions_E, Master_Sequence.

2. Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time, and the job's status is updated to Running.

Running Local Dimension Jobs for Campus Solutions Warehouse

The third step in implementing the Campus Solutions Warehouse is to run the local dimension jobs for Campus Solutions Warehouse. These jobs consist of local dimension hash file jobs and local dimension jobs. Run the hash file jobs first, as the tables they load are required to run your standard global dimension jobs.

Note. You can run local dimension jobs individually or together using the master sequence job.

Local Dimension Hash File Jobs

Perform the following steps to run the local dimension hash file jobs individually:

1. In IBM WebSphere DataStage Director, navigate to the global dimension hash file jobs by expanding the nodes in the left navigation panel using the following path: CS_E, Local_Dimensions, OWS_To_MDW, Base, Load_Hash_Files, Server.

2. Select each local dimension hash file job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Perform the following steps to run the local dimension hash file jobs together using the master sequence job:

1. In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, Local_Dimensions, Master_Sequence.

2. Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Local Dimension Jobs

Perform the following steps to run the local dimension jobs individually:

1. In IBM WebSphere DataStage Director, navigate to the local dimension jobs by expanding the nodes in the left navigation panel using the following path: CS_E, Local_Dimensions, OWS_To_MDW, Dimensions, Base, Load_Tables, Sequence.

2. Select each local dimension job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Perform the following steps to run the local dimension jobs together, using the master sequence job:

1. In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, Local_Dimensions, Master_Sequence.

2. Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time, and the job's status is updated to Running.

Running Campus Solutions Warehouse SKU Jobs

The fourth and final step in implementing the Campus Solutions Warehouse is to run the Campus Solutions Warehouse SKU jobs. These jobs consist of hash file jobs, dimension jobs, and fact jobs. Run the hash file jobs first, as the tables that they load are required to run your dimension and fact jobs.

Note. You can run Campus Solutions Warehouse SKU jobs individually or together using the master sequence job.

Campus Solutions Warehouse SKU Hash File Jobs

Perform the following steps to run the Campus Solutions Warehouse SKU hash file jobs individually:

1. In IBM WebSphere DataStage Director, navigate to the CS Warehouse SKU hash file jobs by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], OWS_To_MDW, Dimensions, Base, Load_Hash_Files, Server.

2. Select each hash file job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Perform the following steps to run the CS Warehouse SKU hash file jobs together using the master sequence job:

1. In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], Master_Sequence.

2. Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Campus Solutions Warehouse Dimension Jobs

Perform the following steps to run the Campus Solutions Warehouse dimension jobs individually:

1. In IBM WebSphere DataStage Director, navigate to the CS Warehouse dimension jobs by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], OWS_To_MDW, Dimensions, Base, Load_Tables, Sequence.

2. Select each dimension job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Perform the following steps to run the CS Warehouse dimension jobs together using the master sequence job:

1. In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], Master_Sequence..

2. Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time, and the job's status is updated to Running.

Campus Solutions Warehouse Fact Jobs

Perform the following steps to run the Campus Solutions Warehouse fact jobs individually:

1. In IBM WebSphere DataStage Director, navigate to the CS Warehouse fact jobs by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], OWS_To_MDW, Facts, Base, Load_Tables, Sequence.

2. Select each fact job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.

Perform the following steps to run the fact jobs together using the master sequence job:

1. In IBM WebSphere DataStage Director, navigate to the master sequence job by expanding the nodes in the left navigation panel using the following path: CS_E, [SKU/Data Mart Name], [Business Process], Master_Sequence.

2. Select the master sequence job in the Job Status view and select Job, Run Now... from the menu.

   The Job Run Options box appears.

3. Update the job parameters if necessary and click Run.

   The job is scheduled to run with the current date and time and the job's status is updated to Running.