Query Task Baseline Work out of Timephased Data table

[Nick Morrison]

I am trying to query information out of the Project Server 2003 database to
assist
us in automating one of our reports. The value I am trying to obtain is based
on the weekly baseline work values that are found in the Task Usage details
view. The value is the cumulative baseline work up to a specific week in
time. For example, the week of 10/6 the estimated (baseline) work to be
completed on Task 1 is 10 days for the week, the week of 10/13, 5.5 days of
work is estimated to be completed on Task 1 for a total of 15.5 days. As time
goes on, the value gets closer to the Task Baseline work. I know it is stored
in the Timephased Data table, but I'm not sure how to get the data in a
usable form. Has anyone written a query to obtain this type of data from the
database over a long period of time?

 

[Gary L. Chefetz [MVP]]

Nick:

Have you looked at prjdb.htm and svrdb.htm which are the data dictionaries
for both Project and Project Server respectively? These are installed in the
help directory on your server and contain sample querys for timephased data
and a whole bunch of other examples.

 

[Nick Morrison]

Hi Gary,

Thanks for the reply and idea! I have not looked at those examples, but am
going through the process of modifying the code to our needs. We found a
procedure that looked similar to these examples in the SDK download from the
MS site. We thought we may have to go the procedure route since we had a
variable date that we pull data for. I'm going to try and modify the "Find
all timephased data for a particular resource" example and taylor it to pull
info for the task and not the resource and also to pull baseline work. I'll
let you know how it goes. Any other thoughts would be helpful. Thanks!

 

[Nick Morrison]

Hi Gary,

I tried looking at and modifying those examples but still haven't been able
to find a solution yet. Any other ideas?

Thanks,

Nick