Grigory Bushuev

Hi, my pm sees the 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 have to get data not from cube. 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.

Sorry if my post is offtopic.



Re: Visual Studio Tools for Office Project base cost not from MS Project Cube

Cindy Meister

Yes, it's definitely off-topic. You'll find a list of newsgroups for Office automation questions in the Please Read First message at the top of the forum, including a link for the Project programming group.