The definition of the Allocation and Assignment 'COST' report database views utilize 'sliced' units and the Rate Matrix Extraction cost and rates data to calculate the costs of assignments and allocations for calendar periods of (D)aily, (W)eekly, (M)onthly, and (Q)uarterly.
The (D)aily report database views generate correct cost values for the total daily sliced units.
The other periods are not calculated correctly when the rate matrix configuration has different rates configured during the other period ranges.
Use Case Scenario:
Project does not start on the first day of the month, does not start on the first day of the quarter or does not start on the first day of the week. When this occurs, the database view will return an incorrect cost because the 'slice' date will not fall within the date range in the rate matrix extraction table.
The Rate Matrix Rows have multiple rates during a week, during a month and during a quarter period. When this occurs, the database view will return only one cost because the 'slice' date is only for one date (the first day of the week, month or quarter)
The steps outlined are for Team Allocation values and comparison of data for the database views were looked at for RPT_PRJ_*_ALLOC_COST_V views. The same behavior applies to the RPT_RES_*_ALLOC_COST_V views and for the PRJ and RES 'ASSIGN' cost views. The steps outlined only trace the data for a LABOR resource. The same behavior applies for the other types of resources (Equipment, Material, Expense)
Database Views Affected:
RPT_PRJ_M_ALLOC_COST_V RPT_RES_M_ALLOC_COST_V TIMESLICES USED: MONTHLYRESOURCEALLOCCURVE, MONTHLYRESOURCEHARDALLOC RPT_PRJ_Q_ALLOC_COST_V RPT_RES_Q_ALLOC_COST_V TIMESLICES USED: QUARTERLYRESOURCEALLOCCURVE, QUARTERLYRESOURCEHARDALLOC RPT_PRJ_W_ALLOC_COST_V RPT_RES_W_ALLOC_COST_V TIMESLICES USED: WEEKLYRESOURCEALLOCCURVE, WEEKLYRESOURCEHARDALLOC RPT_PRJ_M_ASSIGN_COST_V RPT_RES_M_ASSIGN_COST_V TIMESLICES USED: MONTHLYRESOURCEBASECURVE, MONTHLYBASEASSIGNCOSTS RPT_PRJ_Q_ASSIGN_COST_V RPT_RES_Q_ASSIGN_COST_V TIMESLICES USED: QUARTERLYRESOURCEBASECURVE, QUARTERLYBASEASSIGNCOSTS RPT_PRJ_W_ASSIGN_COST_V RPT_RES_W_ASSIGN_COST_V TIMESLICES USED: WEEKLYRESOURCEBASECURVE, WEEKLYBASEASSIGNCOSTS
Steps to Reproduce:
Expected Result: Weekly, Monthly, Quarterly calculations should equate to summation of Daily values
Actual Result: Weekly, Monthly, Quarterly calculations use 'slice' date to find the cost rate in the matrix.
Caused by CLRT-71952
This is identified as a 'Known Defect'. There are no current plans to make changes to this area of the product.
For On Premise Customers Only:
Define alternative database views to sum the daily calculated amounts (ie. from RPT_PRJ_D_ALLOC_COST_V) using a 'group by' clause for the reporting calendar hierarchy level such as weekly, monthly, quarterly, yearly. Refer to the Technical Reference Guide for specific details on the NBI_DIM_CALENDAR_TIME fields.
Click Here for a document that provides sample queries which have been reviewed by our development team.
If you use these queries be sure to implement them in a manner that 'requires' the use of passing a value for the PROJECT_ID and HIERARCHY_LEVEL parameters.
Details are given in the attachment showing what valid values should be passed as parameters.
Reference Customer Reported Known Defects and our CA PPM Customer Defect Resolution Policy.