CA PPM: Rate Matrix Extraction Job Performance

Document ID : KB000007301
Last Modified Date : 18/07/2018
Show Technical Document Details
Issue:

The Rate Matrix Extraction is a job which provides the breakout rates for a project-resource-task combination by date.

It will take the information that is in the live PPA_MATRIX/PPA_MATRIXVALUES table and generate records in the table of rates: NBI_PROJ_RES_RATES_AND_COSTS
which is to be used by various actions/jobs in PPM, from which to obtain a rate.
 

Cause:

The runtime of the job can increase significantly and is influenced by several factors.

A. PPM Rate Matrix Setup in Administration > Data Administration > Time Slices
B. PPM Project/Task/Resource changes
C. Database Configuration/Changes/Maintenance/Issues

Resolution:

1. The first factor is how the live rate matrix is set up. The more columns that are added to the matrix, the more time is needed to insert records into the rate table: NBI_PROJ_RES_RATES_AND_COSTS

Once the rates are available in this table, by way of the Rate Matrix Extraction job completion, the rates are then made available to the following actions:

-Running the Post Timesheets job
-Baselining projects
-Baselining tasks
-Running the Update Earned Value Totals job  (or clicking Project > Action > Update Cost Totals)
-Running the Update Earned Value History job
-Opening OWB or MSP

Therefore, timing is very important.

If changes are made to the live rate matrix, the rate changes will not be made until the RME job is ran.

2. The second set of factors that influence the runtime of the Rate Matrix Extraction (RME) job is the number of projects, resources, tasks that exist in the system.
As the number of projects increase, so does  the number of resources assigned to tasks on the projects.
The following best practices can lower the job runtime, therefore forcing project managers to maintain projects:

a. Remove any rate matrices from Admin > Finance > Setup > Defaults > Project Transaction Entry Defaults
b. Remove any rate matrices from Admin > Finance > Setup > Entities, that are no longer used
c. Remove matrices from inactive investments
d. Deactivate and close out projects that are no longer relevant. 

3. The third factor is whether or not the database maintenance is being performed by the DBA team. 

Over time, database performance can suffer, causing one or more jobs to take longer to run due to a lack of maintenance. Once maintained, the performance can and will improve overall.
 

 

 

 

Additional Information:
On the 'Rate Matrix Extraction' job page, what do the parameters 'Prepare Rate Matrix Data' and 'Update Rate Matrix Data' do? kb000027005

On the 'Rate Matrix Extraction' job page, what does the parameter 'Extract Cost and Rate Information for the Scheduler' do? kb000027082

How should I use the Incremental only option for the rate Matrix Extraction Job? kb000021877​

If rates beyond the start and finish dates of the projects for OWB or MSP, then it can be unchecked. This should effectively reduce the runtime.
Let us know if the runtime does reduce after unchecking it. There may not be a business need to get those rates for the schedulers.

CA PPM Tip: Rate Matrix Configuration