none
actuals, not approved yet, not in cube RRS feed

  • Question

  • A resource submitted 9 hours to a task for day x and is not yet approved by the PM. Why is the cube not picking up task actuals if the task is not approved? Once approved and published, the cube shows the correct hours.

    Is there a way we can show the hours on the Cube reports of hours entered by the resource even if its not approved yet?

    Sunday, January 27, 2013 8:55 AM

All replies

  • Hi,

    sorry, there is no way to get unapproved actuals into cube. Only approved and published data is available in Reporting DB and this DB is the source of cubes.

    Regards
    Barbara

    Sunday, January 27, 2013 9:19 AM
    Moderator
  • Only approved and published data is available in Reporting DB and this DB is the source of cubes.

    Hi SameerwKhan,

    as written, all reports only take into account the last published version of the project. The data which users have entered is in the so-called statusing and not available in the relational databases.

    However, you may use timesheets for reporting submitted data. Any work entered into timesheets is immediately available after saving, regardless of the approval and publishing status. Microsoft also recently announced that timesheets are the preferred method of tracking work hours on a day-to-day basis.

    Kind regards,
    Adrian

    Monday, January 28, 2013 12:47 AM
  • Hi SameerwKhan,

    if you want to follow Adrian's advice, you should read http://technet.microsoft.com/en-us/library/hh694531.aspx carefully and enable Single Entry Mode (SEM).

    Regards
    Barbara

    Monday, January 28, 2013 7:22 AM
    Moderator