none
To fectch resource Plan Administrative Time in Project Server 2007 RRS feed

  • Question

  • Hello Folks,

    Is there any other way by which a Project Manager can see all his resource Plan Admin Time off.

    Means out of box or through SQL Report.

    Thanks !!!

    Wednesday, September 26, 2012 4:51 PM

Answers

All replies

  • I think you may able use Data Analysis views using OLAP cube database


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful; if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Wednesday, September 26, 2012 7:39 PM
    Moderator
  • Thanks Hrishi,

    I have worked on your suggestion and tried to create one data anaylsis view using Resource Time Phased Cube, but there I didn't find any dimension which shows Resource Plan Administrative Time Off or any information related to this. So I think this way I cant fetch this information, please correct me if I am wrong here.

    So do you have any idea where this information stores in PWA databases(Draft/Reporting/Prublish/Archive) so that I can query the database and fetch the required info.

    In case It cant be fetch from database then is there any PSI/Web Service available thru which I can fetch users Plan Admin Time Off.

    Thanks !!!

    Thursday, September 27, 2012 7:40 AM
  • I hope the link below will be of help to you:

    http://social.technet.microsoft.com/Forums/en-US/projserv2010setup/thread/c18d1fab-86c5-4c92-91c1-d6cf1f0b1851


    Thanks and Regards, Roopkumar Kamat (MCITP)

    • Marked as answer by BPAdmin2013 Thursday, September 27, 2012 1:28 PM
    Thursday, September 27, 2012 12:08 PM
  • Thanks Roopkumar,

    That query worked absolutely fine, I am able to fetch all Admin Planned Time off from database.

    Thursday, September 27, 2012 1:29 PM