Using "ReadStatusTimephasedData" in PSI RRS feed

  • Question

  • Hi ,

    We are using project server 2007

      I wanted to develop a report; requirement was to show all the submitted time of the resource and that which is awaiting project manager's approval when resource uses "MyTasks" to update time

     I am using 

    PSI Statusing Method : ReadStatusTimephasedData

    to retrieve this data for the report. I am ok and the report is picking up values but it brings up all the hours whether it is "Only saved work hours" or "Submitted hours" or "approved" and "Published"     

    I want to avoid the "Saved work hours" in my report. How can i do that using the PSI. Thanks for throwing some light on this


    Tuesday, March 13, 2012 11:38 AM

All replies

  • Hi MP,

    Did you try to filter the records using "ASSN_TRANS_ACTION_ENUM = 0" in StatusingTimephasedActualsDataSet , which means that hours are Saved but not Submitted.

    Apart from that , I have used the Task Compliance report of projects erver 2007 report pack 2 which works well. Writing the PSI code might be time consuming. Please refer to the below article:

    Once you download the Report pack, Open the solution in BIDS & see the SQL query for Task Compliance report under EPM Governance Reports.

    Hope that helps.

    Thanks, Amit Khare |EPM Consultant| Blog:

    Tuesday, March 13, 2012 11:52 AM
  • Thanks Amit. Yeah I do admit the fact that PSI is time consuming but as i have already developled and am thru it 90% would like to go forward with PSI approach. Could  you please guide me in how the filter can be applied to StatusingTimephasedActualsDataSet..Had searched in google but didn't find that is help to me..

    Thanks in adavance.

    Tuesday, March 13, 2012 12:32 PM
  • Can Someone please help me out..
    Wednesday, March 14, 2012 9:55 AM
  • Hi Max Pin,

    Sorry for the delayed response. I check the Statusing PSI calls & found that, If you use the ASSN_TRANS_ACTION_ENUM is from the ApprovalDataset, here we are looking into the assignment data of a resource. based on the testing, There is a column in Assignment table of StatusingDataSet "WASSN_SEND_UPDATE_NEEDED", if the value is true & ASSN_ACT_WORK has value,  means that resource has saved the hours but not submitted.

    StatusingSvc.Statusing status = new StatusingSvc.Statusing();
                    status.UseDefaultCredentials = true;
                    Guid resuid = new Guid("AAF0443F-8D7C-48AB-AA15-D224C27FCFA2");
                    Guid assnUid = new Guid("88073781-dcf4-4f24-80ce-69913eeed6d7");
                    StatusingSvc.StatusingDataSet statusingDs =
                        status.ReadStatusForResource(resuid, assnUid, minDate, maxDate);
                    StatusingSvc.StatusingTimephasedActualsDataSet statusingTimephasedActualsDs = status.ReadStatusTimephasedData(projectGuid, assnUid, minDate, maxDate, 60);

    To verify the same, You can save some hours in your MyTask & then run the cose to verify both columns & see the result.

    Hope that helps.

    Thanks, Amit Khare |EPM Consultant| Blog:

    Wednesday, March 14, 2012 12:26 PM
  • Thanks Amit for your findings.What i could find was that Assignment table will allways give the summation of work for a task , so the value in ASSN-ACT_Work  will give me the sum of the hours for the task not on a day by day basis of the assignment for"WASSN_SEND_UPDATE_NEEDED" =true.I am using "ReadStatusTimephasedData" method which will give me all the hours submitted and also the Saved & Rejected hours which i want to eliminate.Please suggest a way for this..

    I couldn't find the ReadStatusForResource method. Is this in Project server 2010??  I am using Project Server 2007.

    Wednesday, March 14, 2012 1:27 PM