none
Timesheet Monitoring Report RRS feed

  • Question

  • Hi,

    Using Project Server 2013

    We have launched EPM Timesheet recently. I want a monitoring report that can show Planned & Actual hours against each resource.

    By utilizing this report, it should help in monitoring that who is filling Timesheet or not.

    Thanks,


    Noman Sohail

    Wednesday, September 7, 2016 12:30 PM

All replies

  • Hi Noman Sohil,

    You can start with the Excel Report that resides in the Reports folder at the PWA level. It may not provide with all your requirements but you can try tweaking it or write a new report based on the TimesheetLine_UserView and The TimesheetActual_OlapView (you'll also want to take a look at the AssignmentByDay table/view).

    Hope this puts you on track.

    Roy  


    Royg

    Thursday, September 8, 2016 11:30 AM
  • Noman,

    You should be able to use this technique.

    http://prasannaadavi.com/2014/06/timesheet-status-report-with-odata-in-projectonline.html#.V9L7__krK00

    I use OData, but you can easily do the same with OLAP Cubes etc., 

    Here is another reference: https://youtu.be/lZWvg4q17JE?t=11m


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   


    Friday, September 9, 2016 6:19 PM
    Moderator