Baseline Costs in database

[AlfredL]

Hi all,

Does anyone know where and how baseline costs 1 - 10 are stored in the
projectserver 2003 database ? I'm using an ADO connection to extract data
for pretty complex Excel reports on all reports held in the database. To be
more precise - what i need are the baseline costs 1 - 10 for assignments on
a daily base in the same way as they're held in the
MSP_VIEW_PROJ_ASSN_TP_BY_DAY table.

Any suggestions are welcome,

Alfred

 

[Ed Morrison]

MSP_Assignment_Baseline. For more information, see the PJSVRDB.HTM and
PJDB.HTM files in \Program Files\Microsoft Office Project Server
2003\HELP\1033 of your Project Server Installation.

 

[AlfredL]

Well,

MSP_ASSIGNMENT_BASE_LINES holds baseline costs for the period of the
assignment (e.g 5 days at a cost of 1000,- in total). I need to figure out
these costs on a daily base. Just imagine a total cost of 1000,- (based on a
5 day assignment) is split as
day 1 200
day 2 100
day 3 150
day 4 0
day 5 550
------------------
total 1000

Furthermore we are "mis-using" (sorry for my english) baseline costs 9 as no
plan 9 has ever been saved. As i mentioned before, we make these fields
available to the user by adding them to a view within Project Professional.

Thanks,
Alfred

 

[Ed Morrison]

Alfred,
Baseline data is not stored on a day by day basis. Only the start, finish,
work, cost, and cost per use is saved. Any per day costs or per day work
must be extrapolated using the assumption that the assignment is using a
flat work contour.

I am not sure what the intended use of your report is, but it sounds like
you are trying to compare the original plan with the current plan. You may
want to look into using Earned Value Analysis (EVA) for that.

If EVA does not meet your needs, try creating multiple versions in project
server. Create the versions as archives.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com

 

[Luis Fernando Rodrigues dos Santos]

In the database schema there isn't nothing helpfull.
In the 2007 version it is easy to get, btw in the 2003 it is hard..

I have done a code to extract it from project professional and creates a
tp_by_day customized for baselines.
Do you still need it?


Luis Fernando R. Santos

 

[Luis Fernando Rodrigues dos Santos]

In the database schema there isn't nothing helpfull.
In the 2007 version it is easy to get, btw in the 2003 it is hard..

I have done a code to extract it from project professional and creates a
tp_by_day customized for baselines.
Do you still need it?


Luis Fernando R. Santos