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.