none
PSI [Project Server Integration] Get Resource Actual vs Projected time allocations RRS feed

  • Question

  • Hi ,

    I am new to Project Server 2010. I am looking to create a report where PMO can see the Actual vs Projected time for a resource on all project s/he is working on. The Actual numbers are what the resource enters in the TimeSheets and Projected numbers are those which PMO/Project Manager enters for the resource in Project Center (project site) Resource list.

    Up till now I have read up on Web Services offered by SharePoint to read lists, Web Servies for PSI Projects and Resources and also the other option of directly getting the data from Project Center Reporting database.

    Can anyone please tell me what approach I should Adopt and how?

    Thanks a lot!


    Sunday, March 17, 2013 5:31 AM

All replies

  • Hi,

    You can directly query Project Server Reporting Database as well. There're several Views which help you get the full data of a particular project and tasks.

    Web Service or PSI are used for modifying data but of course you can use it for viewing as well. But what you're looking for, can be easily be done through directly querying Reporting database and this is the correct approach. If you've set up Excel Service reporting, you can see how it's using queries to get the data.

    Hope this helps!

    Thanks


    IN
    Thanks, Kashif

    Sunday, March 17, 2013 9:21 PM
  • Hi Kashif,

    Thanks for replying. Could you please tell me what is the Excel service reporting?

    The reason I was a little skeptical about querying direct reporting database was that I don't understand their database schema that well and would have to do a lot of guess work/trial and error.   

    Sunday, March 17, 2013 10:32 PM
  • Hi there,

    The Reporting database schema is available in the Project 2010 SDK:

    http://www.microsoft.com/en-gb/download/details.aspx?id=15511

    It will be a lot easier and quicker to get this data from the Reporting DB.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Sunday, March 17, 2013 10:37 PM
    Moderator
  • Thanks Paul. Is it possible to get all the fields I need for this report from PSI web services or should I just explore the reporting database? When I poked around the PSI servies for Projects and Resources, they were't returning whole lot of columns i needed which reporting database views do. I am just confused which route to go.
    Sunday, March 17, 2013 11:48 PM
  • Ade1981 --
     
    Why do you think you need to use PSI to generate the report you seek?  A much, much simpler approach would be to create a Business Intelligence Center report that includes the Resource List and Project List dimensions in the Row Fields drop area, along with Actual Work and Remaining Work in the Total Fields drop area.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Monday, March 18, 2013 1:03 AM
    Moderator
  • I understand you're new to PS and getting hold of it would take a bit time :)

    To quickly understand Reporting Database, I would suggest you download  sdk for PS and then go to Start > All Programs > Microsoft SDKs > Project 2010 SDK > Reporting Database Schema, there you'll find really helpful schema information.


    IN
    Thanks, Kashif

    Monday, March 18, 2013 6:07 AM