Getting base cost of project not from cube

[Grigory Bushuev]

Hi,
I have to get base costs of the projects stored in the MS Project,(i think
it must be
sum of the all project tasks). Base costs i must get not from
cube(MSP_CUBE_ASSN_FACT).
How to do it?

 

[Rod Gill]

In Project Server 2003 read the MSP_VIEW table for tasks. Task 0 is the
project summary task, so costs for Task 0 are the total for the whole
project.

In Project Server read the Reporting database and the MSP_Project_User View.

--

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

 

[Grigory Bushuev]

My PM see data in MS Project like this:

select PROJ_NAME, sum(ASSN_BASELINECOST) as BaseCost
from dbo.MSP_CUBE_PROJECTS proj
inner join dbo.MSP_CUBE_ASSN_FACT as fact
on fact.PROJ_UID = proj.PROJ_UID
group by PROJ_NAME

I made this sql query:

select ProjectTitle, TaskBaselineCost as BaseCost
from dbo.MSP_VIEW_PROJ_PROJECTS_STD proj
inner join dbo.MSP_VIEW_PROJ_TASKS_STD as task
on task.WPROJ_ID = proj.WPROJ_ID
where TaskUniqueID = 0
order by ProjectTitle

but result is differ. Result must be the same.

 

[Rod Gill]

Depends when the cube is built and when the project was last published.
Publish projects then rebuild the cube then test.

If you need costs for unpublished projects, use the MSP_Tasks table.

--

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