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

Document ID : KB000027005
Last Modified Date : 14/02/2018
Show Technical Document Details

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

Solution:
Prior to adding the new parameters when the job ran the NBI_PROJ_RES_RATES_AND_COSTS table was truncated, then rebuilt with the most current rate information.

For large datasets the rebuilding of the table could take several minutes to hours. During this time projects did not have access to the information which lead to resources having a rate of zero.

We added the two new parameters so the NBI_PROJ_RES_RATES_AND_COSTS table will always have data available for use by the schedulers.

The 'Prepare Rate Matrix Data' parameter refreshes the NBI_PROJ_RES_RATES_AND_COSTSCP table with the most recent rate information. This may take a few seconds to hours depending on your data. During this time projects still have access to the rate information in the NBI_PROJ_RES_RATES_AND_COSTS table. The NBI_PROJ_RES_RATES_AND_COSTSCP is a 'staging' table that is only used to hold the data that is prepared.

The 'Update Rate Matrix Data' parameter copies the contents of the NBI_PROJ_RES_RATES_AND_COSTSCP table to the NBI_PROJ_RES_RATES_AND_COSTS table. This should take a matter of seconds to complete. The purpose of this option is to update the live table (NBI_PROJ_RES_RATES_AND_COSTS) with data in the 'staging' table (NBI_PROJ_RES_RATES_AND_COSTSCP).

Therefore, once the Rate Matrix Extraction Job has completed, the schedulers should now reflect the most current rate information, using the NBI_PROJ_RES_RATES_AND_COSTS table.

Figure 1


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

Reference  TEC474741: What does the Rate Matrix Extraction job do and how is it used?