Rate Matrix Extraction: Combinations explained
search cancel

Rate Matrix Extraction: Combinations explained

book

Article ID: 201583

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

What happens when we run with the following combinations of the Rate Matrix Extraction (RME) job:

  • Extract Cost and Rate Information for the scheduler
  • Prepare Rate Matrix Data
  • Update Rate Matrix Data
  • Incremental Update only
  • Team Rates Only

Resolution

See below what tables are processed, updated based on the options selected

RME(Extract) does nothing by itself

  • NBI_PROJ_RES_RATES_AND_COSTSCP is unchanged.
  • NBI_PROJ_RES_RATES_AND_COSTS is unchanged.

RME(Prepare) prepares the rates

  • NBI_PROJ_RES_RATES_AND_COSTSCP is populated.
  • NBI_PROJ_RES_RATES_AND_COSTS is unchanged.

RME(Update) does nothing by itself

  • NBI_PROJ_RES_RATES_AND_COSTSCP is unchanged.
  • NBI_PROJ_RES_RATES_AND_COSTS is unchanged.

RME(Incremental) does nothing by itself

  • NBI_PROJ_RES_RATES_AND_COSTSCP is unchanged.
  • NBI_PROJ_RES_RATES_AND_COSTS is unchanged.

RME(Extract, Prepare) prepares the rates and extracts rates beyond project ranges for Schedulers

  • NBI_PROJ_RES_RATES_AND_COSTSCP is populated.
  • NBI_PROJ_RES_RATES_AND_COSTS is unchanged.

RME(Extract, Prepare, Update) aka "full RME", which is run off-hours nightly


Prepares the rates and extracts rates beyond project ranges for Schedulers and updates the main table

  • NBI_PROJ_RES_RATES_AND_COSTSCP is populated.
  • NBI_PROJ_RES_RATES_AND_COSTS is populated with data from NBI_PROJ_RES_RATES_AND_COSTSCP;

RME (Extract, Prepare, Update, Incremental) aka "incremental RME"

This is run during the daytime for performance and immediate rates. This prepares the rates and extracts rates beyond project ranges for Schedulers, updates the temp table

  • NBI_PROJ_RES_RATES_AND_COSTSCP is truncated.
  • NBI_PROJ_RES_RATES_AND_COSTS is populated.

Records to be processed:

SELECT '(PREPARE) NBI_PROJ_RES_RATES_AND_COSTSCP', COUNT(*)
FROM NBI_PROJ_RES_RATES_AND_COSTSCP --temporary, populated by RME.prepare option
UNION
select '(UPDATE) NBI_PROJ_RES_RATES_AND_COSTS', COUNT(*)
from NBI_PROJ_RES_RATES_AND_COSTS --live, populated by RME.update option

Additional Information

The incremental RME will only pick the following projects after the last successful job run:

  1. Project is active.
  2. Project is updated.
  3. One or more project tasks are updated.
  4. One or more team members are added or changed.
  5. One or more assignments are added or changed.
  6. One or more matrix associations within the project, changes (labor/material/expense/equipment - rate and cost source settings in project financial page
  7. One or more associated matrices change
  8. Entity associated with the project changes.
  9. Matrix associated with the project entity changes.
  10. Transaction entry defaults change (system-wide rate matrix setting).
  11. Any matrix associated with the transaction entry defaults changes.
  12. Financial information of one or more team members on the project changes. (resource financials)
  13. Project is inactive
  14. One or more team members are deleted (removed)
  15. One or more assignments are deleted(removed)
  16. Matrix is deleted.
  17. One or more resources attached to the project are deleted.