Project and Portfolio Management Practitioners Forum
cancel

Cost by resource, effort and task

Highlighted
George_Colsa
Frequent Contributor.

Cost by resource, effort and task

I am trying to get (by SQL query) the cost (planned and actuals) related to each users that has effort into workplan taks. I mean, If a task has three (3) resources with differents efforts each one, what is the cost by each resource in that taks into the workplan.

I am looking for a table with the specific information but is not possible get it.

All the tables has the total cost of the taks, but not by each resources into the task.

 

Any one has idea about this issue.

 

Thank you.

2 REPLIES
Utkarsh_Mishra
Acclaimed Contributor.

Re: Cost by resource, effort and task

Try to explore Time Management -> Work Allocation Details (Report)....

In this you may find your table...

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
George_Colsa
Frequent Contributor.

Re: Cost by resource, effort and task

I have the table WP_WORK_UNITS, and I have the work allocations in projects. How I can know the cost of each work unit??? This data is into other table???