Baselines costs in the database ?

[Jean-luc chantry]

Hello,
I'm tring to find in which table are stored Baselines cost 1,2,3, ...10 in
the database and I can't find.
Do some one know where are they stored ??
Thanks
Jean-Luc

 

[Gary Chefetz [MVP]]

Jean-luc:

Have you looked at the following tables:?

MSP_TASK_BASELINES
MSP_RESOURCE_BASELINES
MSP_ASSIGNMENT_BASELINES


--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

 

[Jean-luc chantry]

Yes , but I don't see any field corresponding.

May be the informations are stored in a complicated way, and the fieds
Baseline cost 1 to 10 are not visible so easyly ??

JL

 

[Gary Chefetz [MVP]]

Jean-luc:

I believe that the default baseline values are stored at the task, resource,
assignment and Project levels within their respective records. Additional
baselines (the alternates) are stored in the extended tables noted in the
previous post. If you don't understand the field structure of the tables,
then you should use projdb.htm as a reference guide. This document was
installed on your hard drive along with Project Pro. On the server side, see
svrdb.htm for a database reference.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.

 

[Jean-Luc.Chantry]

Thanks Gary for your response,
I found Projdb.htm, but it concerns Project 2000 and not 2002. Project Pro
2002 is installed on my computor.
Baseline cost 1 to 10 is a new feature of msp 2002.
Do you know where I can find the same for 2002 ?

 

[Jean-Luc.Chantry]

Sorry I found the document, ....but I still look for may Baselin 1 to 10 !!

 

[Jean-Luc.Chantry]

OK i begin to understand :

Storage of that new baseline is completly different of the Original
baseline.
The are all stored in "bulk in the TB_COST_BASE of the MSP_TASK_BASELINES.
A number in the TB_BAS_NUM say if it's Baseline1, baseline2, ...

The question is :
-Will it be easy to add these Baselines as a measure in OLAP cube
-If I succed how time dimension will work ? I mean, will the cost in
baseline1 be schedule in the cube whith the baseline start 1 ??

JL

 

[Gary Chefetz [MVP]]

Jean-Luc

I've never heard anyone claim that extending the OLAP cube is easy. In fact,
most report much frustration. If you're a good coder, you can do it. See the
information available on http://msdn.microsoft.com .

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.