MSP_EpmAssignmentByDay_UserView Reporting Table RRS feed

  • Question

  • Hello,

    this Table ist used for an Interface that transfers timesheet data to SAP

    The Problem is, we have around 700 Projects. For the most Projcts, the MSP_EpmAssignmentByDay_UserView has the right data, but in some cases the Data is wrong. (Projects are already published, all timesheet approvals are ok)

    For the "OK" Projects the actual values in MSP Clint and in the MSP_EpmAssignmentByDay_UserView are the same

    For the "NOT OK" Projekts MSP_EpmAssignmentByDay_UserView Shows wrong informations.

    TimeByDay ProjectUID TaskUID AssignmentActualWork
    2015-11-04 00:00:00.000  E6070254-CDCE-4F1A-A6F2-5279E4164C49 0.500000
    2015-11-05 00:00:00.000  E6070254-CDCE-4F1A-A6F2-5279E4164C49 3.000000
    2016-11-23 00:00:00.000  C16574DA-7D4D-4E07-BDFB-09C71B7FD462 5.333704
    2016-11-24 00:00:00.000  C16574DA-7D4D-4E07-BDFB-09C71B7FD462 5.333704
    2016-11-25 00:00:00.000  C16574DA-7D4D-4E07-BDFB-09C71B7FD462 5.332593

    MSP Client Shows only 16 Hours for the 23.11.16 (The same is in the Timesheet of the Resource)

    Noware are 0.5 or 3.0 hours ar booked to this Project. In this case it seems to be random that 3*5.333.. =16 (16h i saw in Project on 2016-11-23)

    Where the diffrences comes from?

    We find out, that an administrative backup and restore of the enterprice fields slove this Problem for some Projects, but not for all.

    Any Ideas?

    Best Regards, Oliver

    Tuesday, February 21, 2017 4:24 PM