Kathryn_Ellis

CA PPM Tuesday Tip: Rate Matrix Configuration

Discussion created by Kathryn_Ellis Employee on Jun 3, 2015
Latest reply on May 8, 2018 by vivianfulk_TCH

If my Investment does not have a Rate Matrix selected on the Financials Settings page, where are the rates coming from?

 

If you create a new investment and have not executed the Rate Matrix Extraction job, the Extraction table (NBI_PROJ_RES_RATES_AND_COSTS) will not have a rate until one of the following actions have occurred and you have the Rate Matrix On The Fly setting enabled: 

  1. Post Timesheets Job: If no rates are found in the extraction table, the job will find the matrix based on the rules below and populate the extraction table and update the investment ACWP.
    • It is very important to check your matrix configuration before posting timesheets on new investments or existing investments where new team members have been added since the last successful execution of the Rate Matrix Extraction job so that you will have the expected actual cost rates.
  2. Create a Baseline: If no rates are found in the extraction table, the job will find the matrix based on the rules below and populate the extraction table and update the investment baseline cost attributes.
    • It is very important to check what rates are updated in the extraction table to ensure you have the correct rates before you post any timesheets in this scenario.
  3. Rate Matrix Extraction Job: If no rates are found, running an incremental or full run will populate the extraction table.  If you have executed one of the previous actions before running this job, check your configuration, make matrix changes as needed, and execute a full run of this job to update the existing records in the extraction table.

 

The CA PPM application has a hierarchical logic built-in to check where a matrix can be found.

Here are some rules that can help you check your configuration to locate where your rates are found.

 

  1. If the Investment does not have a matrix selected, the application checks the Entity properties associated with the investment.  The Entity is determined by the Department OBS Unit selected on the Investment.
  2. If the Investment does not have a Department OBS Unit selected, and a Timesheet or a Baseline is created or updated, the application will look for the Datamart Entity Matrix.  
  3. If the Datamart Entity does not have a matrix selected, the application will look to see if there is a matrix configured on the  Financial Setup Default Project Transaction Entry page.
  4. If the Financial Setup Default Project Transaction Entry page does not have a matrix selected, the application will generate a zero rate at the time the rates are extracted into the Rate Matrix Extraction table.
  5. There is an option to configure the Financial, Setup, Defaults page for an Entity.  If there is a matrix selected on this Entity, it is not used for any rate computations from this configuration.
  6. When you configure a Resource's Financial Properties, if there is a matrix selected on the Entity associated with the Department OBS Unit, it is not used for any rate computations from this configuration.
  7. If you have both a Datamart Entity with a matrix and a Default Project Transaction Entry matrix selected, (and no investment matrix), the Datamart matrix rates are used at the time the rates are extracted into the Rate Matrix Extraction table.
  8. When you create a voucher Transaction Entry or a XOG voucher Transaction Entry and no specific rates or costs are defined, there must be a matrix association.

Outcomes