SQL to obtain same results as Portfolio Analyzer

[Chupacabra]

I am working on a project to pull data out of the Project Server 2003
database. What I am attempting to recreate are the Actual Work values that
show up under the "Analyze Project in Portfolio Analyzer" screen.

For example, Project X is at the top of the list of projects. Resources A,
B, and C all have time contributed towards Project X for 2006, and if I
expand 2006, I can see work by quarter, etc.

What I cannot determine is what to query in the Project database in order to
get those same time values for resources A, B, and C for Project X.

If anyone has any pointers as to where to look, or if this is even possible,
I'd greatly appreciate it.

Thanks!

 

[Rod Gill]

In 2003 look at the MSP_VIEW tables, there is a time phased table there. In
2007 look at the Reporting Database.

Apart from that, why try to duplicate what building a cube does?

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Chupacabra]

In 2003 look at the MSP_VIEW tables, there is a time phased table there.
In 2007 look at the Reporting Database.

Apart from that, why try to duplicate what building a cube does?

Because management wants to build reports with a 3rd-party utility to
produce time reports for various departments, and the numbers need to match
up with what Project is reporting