Hi,
I'm trying to connect directly to the SQL database that our Primavera P6 schedules pull from. Doing so will enable automated data extraction for use in our reporting needs.
I'm having a problem linking up the Earned Values shown in P6 with where the data is stored in SQL. In particular, I'm looking for Earned Value Cost by task. From reviewing the PMDB Schema, this data should be stored in the "bcwp" field in either the SUMTASKSPREAD, SUMTASK, TASKSUM, TASKSUMFIN, or TASKFIN tables. However, upon reviewing the SQL database, these tables are all empty for the needed proj_id. The data must be coming from somewhere since it's shown in P6 - any ideas of where else it could be?
Thank you,