Create a query to extract baseline timephased data for tasks

[Nick Morrison]

Hi Everyone,

I'm looking for a query that will cumulate 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 Total Task Baseline work. I think it is stored in the Timephased Data
table, but I'm not sure how to get the data in a usable form. I have looked
at the help files on the Project Server (2003) and in the SDK, but haven't
been able to come up with a solution. Has anyone written a query to obtain
this type of data from the database over a long period of time?

 

[Rod Gill]

Project does not store cumulative baseline work (shame). When I need that
information (EG for an S-Curve), I export to excel and create a cumulative
total there with a formula.

 

[Nick Morrison]

Hi Rod,

That's what we currently do now too, but I believe that the data should be
able to be extracted by SQL still from the timephased data table. If nothing
else, I would at least like to duplicate what is in the details pane of the
task usage view. If I can get that, then I can do a cumulative formula on
that with a macro. The trick is just getting the data out of the database.
Thanks for the help!

Nick

 

[Rod Gill]

You'll need an SQL specialist, it's beyond my skills!