Rate matrix Configuration

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

This KB provides guidance on how to configure the rate matrix which can help avoid issues including the below:

• Incorrect rates where entered and realized.
• Incorrect Team > Allocation Cost is being calculated
• Update Cost Totals values are wrong.

Environment

Release: All Supported Releases

Resolution

1. Have the business unit determine how the rate matrix should be configured. The typical rate matrix will use the only one or two of the following fields to determine the rate.
   • Resource Role or
   • Resource

      2.  Up to 10 columns can be used, but it is best practice to keep it to a minimum. This is because as the higher the number of columns are configured, the higher chance that the Rate Matrix Extraction job will experience performance issues as more projects, resources, and tasks are added over time. Available columns below (From Date and To Date are default values for all rate matrixes) 

• • From Date*
  • To Date*
  • Location
  • Department
  • Resource
  • Resource Class
  • Transaction Class
  • WIP Class
  • Resource Role
  • Charge Code
  • Client Class
  • Department
  • Entity
  • Input Type Code
  • Investment
  • Investment Class

2 a. The Cost fields are calculated as follows:

• Rate

Defines the billing rate to apply to a transaction for the row. A value of at least 0.00 is required. For equipment, materials, and expenses, rate is equal to the quantity. For example, if the cost of a single server is $1,000.00, then the rate is 1.

•  Standard Cost

The standard cost associated with any transaction matching the criteria established in the rate matrix. This attribute is generally not used elsewhere in the product but may be used in developing user-defined cost reporting.

•  Actual Cost

Defines the actual cost that is associated with any transaction matching the criteria established in the matrix. Actual Cost can be used in custom reporting.

 

     3. The rate is determined by the date range, then proceeds to funnel left to right finding a match in each column. Once the match is found, that rate is assigned in the NBI_PROJ_RES_RATES_AND_COSTS table. That is why it is important to test rates and costs via the project > Financial Plans page to see if the correct rate is being retrieved before running the full Rate Matrix Extraction (with parameters Extract for Schedulers, Update, Prepare)

    4. The rate matrix provides real-time rates to cost plans and the Post Transactions to Financials job, and Create WIP Adjustment.

• • In the rate matrix, the rows entered indicate rates retrieved based on the date range. The order of columns matter as it logically attempts to find a matching rate going from left to right. Once the match is found, that rate is assigned in either:
    • to calculate the actual cost when the Post Transactions to Financials job is processing a financial transaction or
    • get inserted into the NBI_PROJ_RES_RATES_AND_COSTS via the Rate Matrix Extraction job where this snapshot rate table will then be made available to the Post Timesheets job and various Project Earned Value calculations and baselines.

Additional Information

PPM Tech Tip: CA PPM Tech Tip: How should the main PPM jobs be scheduled?

See KB: Rate Matrix Extraction Job Performance - Rate Matrix Job Performance