S
Streamline
From the Project Server 2007 reporting database, I am trying to create a
report that compares the ProjectBaselineCost with the ProjectActualCost. The
problem is that when I update the %complete of a baseline task the cost
associated to that task no longer is calculated in the ProjectBaselineCost.
The table/column I am using are:
- MSP_EpmAssignmentByDay_UserView. AssignmentBaseline0Cost AS
“ProjectBaselineCostâ€
- MSP_EpmAssignmentByDay_UserView. AssignmentActualCost) AS
“ProjectActualCostâ€
I have chosen to use the “MSP_EpmAssignmentByDay_UserView†view as this
allows me to filter based on the month. E.g. I can exclude
ProjectBaselineCost into the future such that the actual cost is comparable
to the Baseline cost up until a point in time.
The problem is when I modify the %complete for a baseline task then publish
it (without re-baselining it), the data within the
“MSP_EpmAssignmentBaselineByDay†base table are completely deleted effecting
clobbering my baseline cost.
The only trace of the original baseline cost I can find is in the
“MSP_EpmAssignmentBaseline†table. The problem with this is that the figure
is the grand total (i.e. not distributed over time) which makes it difficult
to calculate the Baseline Cost up until a certain point in time.
Has anyone had similar experience or worked a way around this?
report that compares the ProjectBaselineCost with the ProjectActualCost. The
problem is that when I update the %complete of a baseline task the cost
associated to that task no longer is calculated in the ProjectBaselineCost.
The table/column I am using are:
- MSP_EpmAssignmentByDay_UserView. AssignmentBaseline0Cost AS
“ProjectBaselineCostâ€
- MSP_EpmAssignmentByDay_UserView. AssignmentActualCost) AS
“ProjectActualCostâ€
I have chosen to use the “MSP_EpmAssignmentByDay_UserView†view as this
allows me to filter based on the month. E.g. I can exclude
ProjectBaselineCost into the future such that the actual cost is comparable
to the Baseline cost up until a point in time.
The problem is when I modify the %complete for a baseline task then publish
it (without re-baselining it), the data within the
“MSP_EpmAssignmentBaselineByDay†base table are completely deleted effecting
clobbering my baseline cost.
The only trace of the original baseline cost I can find is in the
“MSP_EpmAssignmentBaseline†table. The problem with this is that the figure
is the grand total (i.e. not distributed over time) which makes it difficult
to calculate the Baseline Cost up until a certain point in time.
Has anyone had similar experience or worked a way around this?