Surrogate timesheet and weird data in timesheet report

[Michał]

Hello

Let's assume that I am user A, and my subordinate is user B.
When I create and submit timesheet on behalf on user B ('Surrogate
timesheet' option in 'My Timesheets'), then in data analysis module I see,
that hours I have reported on behalf on user B are added to me (to user A).
Is this normal ? I don't think so.. when I submit timesheet for user B
(because for example he was seek on Friday..), then I want proper data in
proper place

Is there any solution ?

Regards,
Michał

 

[dj_mac]

I have experienced the same thing....

 

[Gary L. Chefetz [MVP]]

This is a known issue. Pawel, a frequent contributor to this group posted a
fix last December that involves manipulating the database. I repost below
for your convenience:

use SQL Management Studio to
modify one of the ProjectServer_Reporting DB views
(MSP_TimesheetActual_OlapView ) in such a way, that instead of providing the
name/ID of the person who last changed the report, it gives the owner of the
timesheet (what could be expected).

The SQL code that works for us is pasted below, but please use it on your
own responsibility (and don't forget to make a backup of the actual
MSP_TimesheetActual_OlapView definition).

USE [ProjectServer_Reporting]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[MSP_TimesheetActual_OlapView]
AS
SELECT
ta.TimesheetLineUID as TimesheetLineUID,
ta.TimeByDay as TimeByDay,
t.OwnerResourceNameUID as LastChangedResourceNameUID, --This is important
ta.CreatedDate as CreatedDate,
ta.TimeByDay_DayOfWeek as TimeByDay_DayOfWeek,
ta.TimeByDay_DayOfMonth as TimeByDay_DayOfMonth,
ta.AdjustmentUID as AdjustmentUID,
ta.ActualWorkBillable as ActualWorkBillable,
ta.ActualWorkNonBillable as ActualWorkNonBillable,
ta.ActualOvertimeWorkBillable as ActualOvertimeWorkBillable,
ta.ActualOvertimeWorkNonBillable as ActualOvertimeWorkNonBillable,
ta.PlannedWork as PlannedWork,
ta.Comment as Comment
FROM
MSP_TimesheetActual AS ta FULL OUTER JOIN
dbo.MSP_TimesheetLine AS tl ON ta.TimesheetLineUID = tl.TimesheetLineUID
FULL OUTER JOIN
dbo.MSP_Timesheet AS t ON tl.TimesheetUID = t.TimesheetUID
..


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com