CA PPM: Rate Matrix Extraction Job Performance

Document ID:  TEC1691974
Last Modified Date:  07/10/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA PPM

Releases

  • CA PPM:Release:15.2
  • CA PPM:Release:15.1
  • CA PPM:Release:14.4

Components

  • CA PPM FINANCIAL MANAGEMENT INTERNAL ONLY:PPMFNM
Issue:

Rate Matrix Extraction is a critical job in CA PPM in that it provides the breakout rates for a project-resource-task combination by date.



 

Cause:

The runtime of the job can increase significantly and is influenced by several factors.
A. Rate Matrix Setup
B. Project/Task/Resource count
C. Database 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

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:


http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec439334.aspx 
On the 'Rate Matrix Extraction' job page, what do the parameters 'Prepare Rate Matrix Data' and 'Update Rate Matrix Data' do? 

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec439203.aspx 
On the 'Rate Matrix Extraction' job page, what does the parameter 'Extract Cost and Rate Information for the Scheduler' do? 

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.

https://communities.ca.com/thread/241732693
CA PPM Tip: Rate Matrix Configuration

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing