locked
Report RRS feed

  • Question

  • Hi,

     

    This hould be fairly simple. I need to design a report using excel services. I need the report to have a column with project name, another column with project planned work(estimated at the begining og the project) and a third column that adds up all the actual worked hours(based on timesheet inputs) from the different resources assigned to a given project.

    It would be nice to filter it b finished/ongoing projects but can live without it.

     

    Thanks in advance.

    Tuesday, February 15, 2011 5:12 PM

Answers

  • I think you need to check couple of things to conclude why its not giving work as desired

    • Check resource calendar
    • Check Project calendar
    • Check Resource Assignment units, are they assigned 100%
    • Navigate to resource usage view and check if in thier assignments everyday they are assigned for 8hrs per day or is it showing less

    I believe this will clarifya s why work is showing lower than expected


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Friday, February 18, 2011 5:57 AM

All replies

  • You can connect Excel to project server OLAP and get the desired data from "EPM Timesheet" cube

    Assuming you are on 2010, there is sample report available in BI centre named TimesheetActuals which you can customize to acoomodate your needs

    Let me know if you need additional information

    For Reporting Configuration refer to  :  http://technet.microsoft.com/en-us/library/ee662106.aspx 


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Tuesday, February 15, 2011 6:02 PM
  • Sunil,

     

    Thanks for your help. As I mentioned above one of the columns needs to be the planned work for a project(given by resources units).

    I have a project with 5 full time resources that lasts 3 months making it a total planned effort of 2400 hs. I added a column called sum of planned effort but instead of getting that number I get 960 hrs. Do you know where this comes from and how can I manage to make it as I intend to?

     

    Thanks for your help

    Wednesday, February 16, 2011 1:27 PM
  • Planned Work corresponds to Baseline Work, Cross verify with the plan if the baseline Work is same? also check if you are extracting the data from OLAP, then your cube has been updated (Built) and is not too old
    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Wednesday, February 16, 2011 2:21 PM
  • I'm struggling to understand your 2400 hours number given the average number of working days and working hours per month, but perhaps you're including a lot of overtime work. Do make sure that you haven't assigned any resources to summary tasks, otherwise your work calculations in Project will be useless.

    I suggest that you Navigate to the Templates library in the BI Center, and begin by using the ProjectsAndAssignments template which will provide you with the data you require. You simply need to know how to build a report in and Excel pivot table.


    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG
    Wednesday, February 16, 2011 3:36 PM
  • A 3 month project with 5 full time resources equals to 800 hours a month(160hs per resource) multiplied by 3 gives a total of 2400 hours for a 3 month project.

    We are using project to track estimated work(written in the SOW) vs real time used to finish the project(via timesheets) so all resources input their hours to one task only that is basically a copy of the entire project.

     

    Anyway Im getting 900 hours as estimated work instead of the 2400 I should be getting.

     

    Thanks!

    Thursday, February 17, 2011 6:37 PM
  • I think you need to check couple of things to conclude why its not giving work as desired

    • Check resource calendar
    • Check Project calendar
    • Check Resource Assignment units, are they assigned 100%
    • Navigate to resource usage view and check if in thier assignments everyday they are assigned for 8hrs per day or is it showing less

    I believe this will clarifya s why work is showing lower than expected


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Friday, February 18, 2011 5:57 AM