S
Streamline
I am trying to create a report that compares the ProjectBaselineCost with the
ProjectActualCost. The problem is that when the 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 the a point in time.
The problem is when I modify the %complete for a baseline task then publish
it, the data within the “MSP_EpmAssignmentBaselineByDay†base table are
completely deleted effecting clobbering the 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?
ProjectActualCost. The problem is that when the 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 the a point in time.
The problem is when I modify the %complete for a baseline task then publish
it, the data within the “MSP_EpmAssignmentBaselineByDay†base table are
completely deleted effecting clobbering the 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?