Working hours from resource calender

[Arthur]

Hi!

We are using Project Server 2003 with admin projects and we collect all
hours from all resources.

Is there some way to retrieve working hours from the resource calendar in
PWA? For instance, if you build a new team you can choose a period of time
and get available time for this period. I assume this is working hours from
the resource calendar minus planned work and actual work. I need to do a
similar calculation, but without the planned work. I need to create a balance
by calculating the difference between working hours from the resource
calendar and actual work for a resource, and this for a given period.
Example: We have a working day of 7.5 hours, for January 2007 this gives us
165 working hours. If a resource has reported more than 165 hours of actual
work during January he will have a positive balance and might take some time
off, if he has less than 165 hours, he will have to work more in February to
catch up.
Is this possible in PWA? If not, is it possible to achieve this
programmatically?

Arthur

 

[Ben Howard]

Hi Arthur, alas no, it's a question for a developer, skills I don't have.
Hopefully there is a PDS query you can make to get this information.

 

[Ben Howard]

Hi Arthur,
Analysis Services will allow you to access Acutal Work per resource per month.
If you export this to excel, and manually add in a column for the hours per
month, you can run the calculation off that.

I don't think there is a way to do this by default, other than extending the
cube.

 

[Arthur]

Hei Ben, thanks for your reply.

I tried another reply on this message, but it seemed to go wrong, so I'll
give it another try.

If we can solve this problem by extending the cube, then thats just great
for us. We're about to extend the cube we have today. I've got someone else
to do this for us because of my lack of knowledge on cubes.

Do you have any idea which tables and fields we need to extend the cube with
to solve my problem?

Arthur

 

[Arthur]

Hi Ben

I will try to gather some more information on this.

Thanks, Arthur

 

[Bill Busby]

Arthur, this is off the cuff so I haven't actually tried it. Seems like it
would be possible to create a view based on the cube with a calculated field
called 'WorkingHours' with a set value of 7.5. Then create a calculated field
called 'WorkDelta' with the calculation of [ActualWorkProtecte] -
[WorkingHours]. The total of this delta at the end of each month should give
you the aggregate over/under work for the resource.