Query Baseline Work out of Timephased Data table

[Nick Morrison]

I am trying to query information out of the Project Server 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?

 

[Mike Glen]

Hi Nick,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP