Clarity Jobs to accommodate business reporting for the organization

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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.

Environment

All Clarity Environments

 

Resolution

Jaspersoft Advanced Reporting jobs

Run the following jobs to get the Jaspersoft Advanced Reporting domains/reports populated.

-Time Slice
-Update Report Tables (select all parameter options as needed)
-Create and Update Jaspersoft Users
-Investment Allocation
-Load Data Warehouse
-Load Data Warehouse Access Rights

Additional Information

The following jobs will populate the Data Warehouse 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
-Time Slicing	Run every minute.   Get time-sliced data available various internal and external slice tables.   Examples: PRJ_BLB_SLICES PRJ_BLB_SLICES_M_ALC
-Investment Allocation	Run only once per day, before the full Rate Matrix Extraction job   Populates the project list page. Updates PRASSIGNMENT Updates INV_INVESTMENTS
-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 incrementally (without the "full load"parameter) at key times during work day. Run with the "Full load" parameter nightly.

 

How to Run Reports from Clarity PPM Reports and Jobs