none
Users have changed the RBS and there is no way to know their timesheet actual work in every RBS, only appears the new one RRS feed

  • Question

  • Hi,

    I'm using Project Server 2010.

    Some users have changed the RBS (I changed it) and now, extracting the information from view MSP_TimesheetLine_UserView, field RBS, I only get the actual RBS, but there is no history for the old one. I need to know how many hours were in the previous one and how many hours in the new one. In the SELECT I'm using the RBS to filter the information (WHERE RBS LIKE 'Department.Section%')

    Do you have any solution for this issue?

    Thank you and regards,

    José Espases

    Wednesday, June 13, 2012 3:47 PM

Answers

  • Unfortunately, the metadata in the Project Server RDB, is mostly not state driven, meaning any changes you make will overwrite the previous data.

    One workaround I can think of is that, use MSP_TimesheetActual_OlapView, where you can view hours by each day and then calculate the hours before the date you made the change, and the hours after the date you made the change.

    Wouldn't that give you the data you are looking for?


    Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com

    Wednesday, June 13, 2012 5:36 PM
    Moderator
  • Thank you for your answer Prasanna,

    Yes, partially it could cover the issue, but I won't be able to use the cube.

    It's really a pity, for the moment the best solution I see is to deactivate this user and to create another one for the new RBS, it creates another problem with the user logon account, as it cannot be there twice, but I will create a ficticious one just to deactivate the user. Doing this I will have two different users and the problem won't be there anymore.

    I really think that this is something for Project Server to think about, maybe in a next version it should be solved.

    Thank you again and regards,

    José Espases

    • Marked as answer by José Espases Thursday, June 14, 2012 8:31 AM
    Thursday, June 14, 2012 8:31 AM

All replies

  • Unfortunately, the metadata in the Project Server RDB, is mostly not state driven, meaning any changes you make will overwrite the previous data.

    One workaround I can think of is that, use MSP_TimesheetActual_OlapView, where you can view hours by each day and then calculate the hours before the date you made the change, and the hours after the date you made the change.

    Wouldn't that give you the data you are looking for?


    Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com

    Wednesday, June 13, 2012 5:36 PM
    Moderator
  • Thank you for your answer Prasanna,

    Yes, partially it could cover the issue, but I won't be able to use the cube.

    It's really a pity, for the moment the best solution I see is to deactivate this user and to create another one for the new RBS, it creates another problem with the user logon account, as it cannot be there twice, but I will create a ficticious one just to deactivate the user. Doing this I will have two different users and the problem won't be there anymore.

    I really think that this is something for Project Server to think about, maybe in a next version it should be solved.

    Thank you again and regards,

    José Espases

    • Marked as answer by José Espases Thursday, June 14, 2012 8:31 AM
    Thursday, June 14, 2012 8:31 AM