none
Work baseline by day for a close task RRS feed

  • Question

  • Hello,

    I want to see the work baseline by day for a close task.

    When we closed the task in the middle of october, the real work (49,5 hours) was less than baseline work (100 hours).

    In view "Use of Tasks" in project, the information in column "Trabajo de línea" (baseline work) is 100 hours but in the distribution by days, it appears only 49,5 hours. It seems that the information for Work real and work of baseline (Trab.prev.) are the same and the deviation (50,5 hours) had been deleted for baseline work.

    In next query on view, “dbo.MSP_EpmAssignmentByDay_UserView” returns the information of BaselineWork, Task Real Work and Variance for this task. The baseline work is 100 hours.

    QUERY

    selectVistaTareas.TaskBaseline0Work,VistaTareas.TaskBaseline1Work,VistaTareas.TaskWork,VistaTareas.TaskActualWork,  VistaTareas.TaskWorkVariance

    fromEPM2010_Reporting.dbo.MSP_EpmTask_UserView VistaTareas

    whereVistaTareas.ProjectUID =  '1CC81E2E-780C-4D49-806A-C417FCE2163A'

    andVistaTareas.TaskUID='81FF7C5A-F2F5-4C4A-BA23-C7E57CCC2F39'

    RESULT OF QUERY

    TaskBaseline0Work=100.000000

    TaskBaseline1Work=NULL 

    TaskWork= 49.500000

    TaskActualWork= 49.500000

    TaskWorkVariance=-50.500000

    But if I try to get the baseline work using view “dbo.MSP_EpmAssigmentByDay_UserView”, the result is 49,5 hours instead when the correct value is 100.

    QUERY

    selectSUM(VistaAsignacionesDia.AssignmentBaseline0Work)asAssignmentBaseline0WorkTotal

    fromEPM2010_Reporting.dbo.MSP_EpmAssignmentByDay_UserView  VistaAsignacionesDia

    whereVistaAsignacionesDia.ProjectUID ='1CC81E2E-780C-4D49-806A-C417FCE2163A'

    ANDVistaAsignacionesDia.TaskUID ='81FF7C5A-F2F5-4C4A-BA23-C7E57CCC2F39'

    RESULT OF QUERY

    AssignmentBaseline0WorkTotal=49.500000

    I this when the task is marked as “Completed” the distribution by day for BaselineWork should not have changed. How can I get the distribution by day for Baseline work?

    Regards,

    Virginia


    • Edited by VLaf Wednesday, June 5, 2019 12:34 PM Additional information
    Wednesday, June 5, 2019 12:29 PM