none
Work and Remaining Work in the Reporting Database RRS feed

  • Question

  • Hi

    When retriving this data from the reporting database, it comes back as hours. Is there any way to get back days instead? e.g. Days Remaining, or Days Actual.

    Thanks

    Monday, May 28, 2012 11:50 AM

All replies

  • Hi There--

    This is now it stores the information in reporting database. You may need to convert the hours in days. For example for standard cal a day means 8 hrs. so if the Actual work on a task assignment (having standard cal) is 16 hrs reported by a resource. the Days actual will be 2days. 

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Monday, May 28, 2012 12:33 PM
  • Thats what I suspected.

    What happens when different calendars are used? Some here have 24 hours, some 7.5

    Monday, May 28, 2012 12:48 PM
  • Then you would have to take the resource calender into consideration: join the resource table or resource view to the assignments table and get the resource calendar name. Then you can change the sql statement with a case-clause and divide the hours depending on the resource calendar.

    Tuesday, May 29, 2012 8:43 AM
  • If the TaskIgnoresResourceCalendar is true, You will need to find the project cal info. I would say that the Calendar info of the project is not stored as name or the GUID. It stores as ProjectCalendarDuration by which you cannot decide the project name. I ran into a similar stuff in past. I had to use the PSI to get the CAL_UID of project & got the details of Calendar using the Calendar web services.

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, May 29, 2012 9:13 AM
  • Amit is right. Calendar information is stored in binary fields in the database which is not readable to anythying but project professional. You would have to get creative in calling the PSI to get this information and then join it to your main query. This would get terribly complicated though. Most of the time people are OK with an indicative figure providing the report shows a legend of 1day = 8hrs for example. Same issue occurs when you try to read out resoure non working time exceptions to report on upcomming leave for exmaple. You would need to handle this as well as task clanedar overrides. YUCKY!!!

    Another creative idea would be to expose a parameter in the report for the user to enter how many hours make up a day. Then use this in your daily calcualtion.


    Regards,

    Piet Remen
    http://pietremen.blogspot.com.au

    Wednesday, May 30, 2012 2:37 PM