The following is suggested for scheduling Clarity Jobs to accommodate business reporting for the organization. There are many jobs in Clarity to generate reporting data. The essential ones are necessary and the order should they be scheduled.
Clarity PPM On Demand
Clarity PPM On Premise
Jaspersoft Advanced Reporting jobs
Run the following jobs to get the Jaspersoft Advanced Reporting domains/reports populated.
-Time Slice
-Update Report Tables
-Create and Update Jaspersoft Users
-Investment Allocation
-Load Data Warehouse
-Load Data Warehouse Access Rights
The following jobs will populate the Datawarehouse database and to the out of the box portlets and Advanced Reporting reports
Suggestions on how to set the duration and incompatible jobs list by navigating to Administration, Data Administration, Reports and Jobs and filtering for the job in question.
|
Job |
Duration/Purpose |
Notes/Job Incompatibility List |
|
-Time Slicing |
Run every minute. Get time-sliced data available various internal and external slice tables.
Examples: PRJ_BLB_SLICES |
Datamart Extraction (Default) Delete Investments (Default) Datamart Rollup (Default) Rate Matrix Extraction (Recommended) Post Timesheets (Recommended) Post Transactions to Financials (Recommended) Investment Allocation (Recommended) Import Financial Actuals (Recommended) Update Earned Value and Cost Totals (Recommended) Load Data Warehouse (Recommended) |
|
-Investment Allocation |
Run only once per day, before the full Rate Matrix Extraction job
Populates the project list page.
|
Load Data Warehouse Time Slicing |
|
-Create and Update Jaspersoft Users |
Run after users have been granted Advanced Reporting access rights. |
|
|
-Update Report Tables -Load Data Warehouse Access Rights -Load Data Warehouse |
Run with the "Full load" parameter nightly. |
Time Slicing (Recommended) |