Project Server Report Pack 2007

[Barbara G]

Hi,
When I view the Timesheet Audit All report in the Report Pack 2007, my hours
are showing incorrectly. For training purposes, I have recalled my timesheet
and the hours are accumulating instead of replacing them. For example, I had
a 40 hour week timesheet and I recalled it. I then re-submitted and
re-imported it. Now, this report is showing 80 hours instead of 40 hours for
that week. I am the Project Server administrator and I have verified Data
Analysis is showing the correct information. I'm wondering if I'm using the
wrong field for the report. Will you please tell me what field, table and
database I should be using?

 

[Barbara Henhapl]

Hi Barbara,

I don't have the report pack available. But I think it will use
MSP_TimesheetActual_OlapView to get actual work? Whenever you are doing
adjustments on timesheets, there are created additional records: one with
the negative old value and one with the new value. They have their
AdjustmentUID in that view. So perhaps your report is selecting
ActualWorkBillable > 0, then you will miss the correction record.

Here an select statement I am using on Reporting DB. You schould find fields
and views in there:
SELECT dbo.MSP_TimesheetActual_OlapView.TimeByDay,
dbo.MSP_TimesheetPeriod_OlapView.PeriodName,
dbo.MSP_TimesheetResource_OlapView.ResourceName,
dbo.MSP_TimesheetProject_OlapView.ProjectName,
dbo.MSP_TimesheetTask_OlapView.TaskName,
SUM(dbo.MSP_TimesheetActual_OlapView.ActualWorkBillable) AS
ActualWorkBillable, dbo.MSP_TimesheetActual_OlapView.AdjustmentUID
FROM dbo.MSP_Timesheet_OlapView INNER JOIN
dbo.MSP_TimesheetLine_OlapView ON dbo.MSP_Timesheet_OlapView.TimesheetUID =
dbo.MSP_TimesheetLine_OlapView.TimesheetUID INNER JOIN
dbo.MSP_TimesheetPeriod_OlapView ON dbo.MSP_Timesheet_OlapView.PeriodUID =
dbo.MSP_TimesheetPeriod_OlapView.PeriodUID INNER JOIN
dbo.MSP_TimesheetActual_OlapView ON
dbo.MSP_TimesheetLine_OlapView.TimesheetLineUID =
dbo.MSP_TimesheetActual_OlapView.TimesheetLineUID INNER JOIN
dbo.MSP_TimesheetProject_OlapView ON
dbo.MSP_TimesheetLine_OlapView.ProjectNameUID =
dbo.MSP_TimesheetProject_OlapView.ProjectNameUID INNER JOIN
dbo.MSP_TimesheetTask_OlapView ON
dbo.MSP_TimesheetLine_OlapView.TaskNameUID =
dbo.MSP_TimesheetTask_OlapView.TaskNameUID INNER JOIN
dbo.MSP_TimesheetResource_OlapView ON
dbo.MSP_Timesheet_OlapView.OwnerResourceNameUID =
dbo.MSP_TimesheetResource_OlapView.ResourceNameUID
GROUP BY dbo.MSP_TimesheetPeriod_OlapView.PeriodName,
dbo.MSP_TimesheetProject_OlapView.ProjectName,
dbo.MSP_TimesheetResource_OlapView.ResourceName,
dbo.MSP_TimesheetActual_OlapView.TimeByDay,
dbo.MSP_TimesheetTask_OlapView.TaskName,
dbo.MSP_TimesheetActual_OlapView.AdjustmentUID

Regards
Barbara