Actual Work - under or over baseline

[Doug Schurman]

Project Server 2003

We are trying develop a report to show us the time entered in a given time
frame (usually last week) and whether or not that time is still within the
baseline for the given assignment. For example if Joe is assigned a task and
is baselined 10 hours, had worked 5 hours prior to last week and then worked
3 more these 3 hours would be “on budgetâ€. If he had already worked 10 or
more prior to last week these 3 hours would all be “over budgetâ€.

All of this raw data is displayed on the timesheet entry tab that would be
needed. We are having a hard time getting this data to be available ether in
Portfolio analyzer or in a custom SQL query. What do we need to be able to do
to pull assignments by person, show total baseline, total timesheet work
entered and show timesheet work entered for a recent period (like last week)?

Thanks
Doug

 

[Marc Soester [MVP]]

Hi Doug,
In Project Server 2003 you will have the abillity to compare the data you
are after only on a project basis, not on a task basis. There is an extention
that you can purchase in order to get task information in 2003 ( type in PEA
Externder into google, it a tool from Bogdanov).

Atlernetafly you can extract the information from the Proejct Server
Database. I would suggest to check out the Project Server 2003 SDK which can
be found on the Microsoft page. This gives you some examples of how to do
that. Please note you will require development skills in order to achieve
this.
Hope this helps

 

[Doug Schurman]

Thanks for the response Marc. We already have an extention for Task data in
the cube but this doesn't satisfy our needs. Also, we have done direct SQL
queries to the tables for some reports.

I can't seem to find the table and field for baselined hours by assignment
though to report on. Also, the web view for timesheet entry already has the
exact details I need. I just need the query that is used for that and to
expand it to include all resources for a specific date range. Is there an
easy way to get the query that's being used for the Timesheet entry view?

Thanks
Doug

 

[Marc Soester [MVP]]

Doug, I would try the project server developer user group. I can imagine that
someone is able to help you with the querie there.
Hope this helps