How can I query timesheets in PS 2007 for metrics?

[DerekM]

I'm evaluating PS 2007 for timesheet usage and I want ot know how I can
easily grab info from all my users for metrics from the timesheet info. Any
ideas?

 

[Ray McCoppin]

In the Project Server 2007 SDK you can ducmentation about the Reporting
Database. In the reporting database there are a number of tables wiht
timesheet information. Also project server 2007 OLAP contains a Timesheet
cube that you could build OLAP views for your metrics. Below is the link to
the SDK.

http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&DisplayLang=en

Hope this helps.