Field Definitions for PS2007

A

Alison

Hello - I am in the process of setting up views for data analysis that I
want people to have access to. What i'm having issues with is know what
fields map to what data.

For example, tracking estimated hours to actual reported time (basic) i
would assume it would be baseline, or work, against actual work, but for some
reason i'm not seeing timesheet data as the actual work.

either way, is there a reference that lists what each field cooresponds to
anywhere?

Thanks (love this board)
 
R

Rod Gill

Hi,

The only fields Microsoft has published details about and are therefore safe
to use are in the Reporting database. Download the schema from the Project
SDK at microsoft.com. The most useful data is in the View ending with
_userview. They have all custom fields added automatically for you.

--

Rod Gill
Project MVP

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

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
 
B

Ben Howard

Download the SDK and check out the OLAPCUBESchemas.xlsx file for details of
which fields are in which cubes.
 
Top