Description:
When a role is added multiple times to a project, the rate is not coming over to Open Workbench (OWB) or Microsoft Project (MSP) as expected, causing possible data corruption. Example steps use MSP, however the same behavior is seen in OWB.
Steps to Reproduce:
- Create a labor role named Business_Role_01
- Define and activate financial properties on the new role
- Create two projects for at least a year, Project_01 and Project_02
- Define and activate financial properties on the 2 projects - selecting a Rate Matrix defined with the 'Resource Role' column
- Add the role to Project_01 two or more times
- Add the role to Project_02 once
- In the rate matrix associated with the projects, create an entry for the role Business_Role_01 from 01/01/1990 to 12/31/2014 for $10.00 in the actual cost field
- In the rate matrix, make sure there is a 'default' matrix row with an actual cost rate from 1990 to 2023 of $140.00. (Enter an asterisk for the columns in the matrix row)
- Execute the 'Rate Matrix Extraction' job with first three options selected
- Extract Cost and Rate Information for the Scheduler
- Prepare Rate Matrix Data
- Update Rate Matrix Data
- Create a Baseline for Project_01 -- Review and see the baseline cost in Clarity
- Open Project_01 in MSP
- Navigate to the Resource sheet
- View the rates for both instances of the role Business_Role_01
Note: you see $0.00 cost rate
- Go to the Resource Information cost tab and note the rate does not start until Jan 1,2015
- Close Project_01 from MSP
- Open Project_02 in MSP
- Review the Resource sheet and you do see the cost rate of $10.00 for the Business_Role_01 role
Expected Result: To see the correct rate for the role, based on the rate matrix when roles are added multiple times
Actual Result: You do not see the rate for this year, and possibly other years depending on how the matrix row dates are defined
Solution:
Workaround:
Only add the role once to a project, which is not acceptable
Status:
Resolved in Clarity 13.3
Keywords: CLARITYKB, CLRT-71363, clarity13resolved, clarity133resolved, msp, owb, role, rate.