How to make actual work visible of other projects?

[Stefan van Aalst]

For each project open I can see Actual Work done on those projects. If I
have only one project open I can see the amount of Work for each resource per
project (even when closed). What I need is to see in MS-Project all the
Actual Work (on project level) per resource without opening all the relevant
projects.

Is this possible? If so how to do this?

Strangely, I see that Overallocation (seems to) contain the numbers I'm
looking for.

In case there is a need to know why, I want to create an report per resource
what the hours they worked on what project per day/week/month. Ideally I
would like to use the cubes, but 'they' decided not to turn on the cubes for
the time being :-(.

Much obliged

Stefan

 

[mark.everett]

Stefan -

You could create a project and assign all your resources to it (don't
assign them to tasks, just to the project). Then modify the Resource
Usage View to provide Actual Work as well as planned. You can adjust
the time scale for Months, Weeks and Days.

Ideally, as you have pointed out, the OLAP cube would be used....

Hope This Helps,
Mark Everett | PMP
www.quantumpm.com

 

[Stefan van Aalst]

Mark

Thanks. I did this. But here is the odd thing:
- the projects involved have several tasks
- those tasks have Actual Work values (this is visible in those projects)
- the projects show up in the resource usage view
- I would expect that the project mentioned below the resource would contain
all the Actual Work done by this resource in this project
- what I see is that the Actual Work is 0
- what is see is that Overallocation contains the expected Actual Work
- when I look into the project that has Overallocation I see no
Overallocation but only Actual Work
- Overallocation value of the project = sum of Actual Value in the project

Here I fail to see the logic. Even when it isn't logical, as long as it is
reliable I'm happy.

Do you have an explanation?

Stefan