Assignment Usage cube

[Shane]

I am trying to extract earned value data from Project Server 2007's
underlying databases. I believe the data can be found in the
Assignment Usage cube. In 2003, the cubes were visable in the
database. However, in 2007, I am unable to locate cube data. Any
suggestions?
Thx

 

[Rod Gill]

The only officially supported data you can mine from the databases is the
Reporting db which also holds interim data for cube building. The schema for
the reporting db is in the SDK. Note that there are some very useful Views
included that automatically hold all custom fields.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

I am trying to extract earned value data from Project Server 2007's
underlying databases. I believe the data can be found in the
Assignment Usage cube. In 2003, the cubes were visable in the
database. However, in 2007, I am unable to locate cube data. Any
suggestions?
Thx

__________ Information from ESET Smart Security, version of virus
signature database 4946 (20100315) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4946 (20100315) __________

The message was checked by ESET Smart Security.

http://www.eset.com