none
OLAP cube not getting actuals updates RRS feed

  • Question

  • Hello,

    I have a project schedule that was corrupted.  We saved a copy locally, deleted the copy, and then re-saved a copy to project center.  All the actuals from the past has been lost and not in the project schedule or the olap cube.  How can we retrieve this information because it is sitting in the resources who are on the project timesheet?

    HELP!!!

    Wednesday, July 11, 2012 3:48 PM

All replies

  • jbprine --
     
    The PM of this project needs to open the project and then save and publish the project.  After the OLAP cube rebuilds, you should see the actuals in the past plus the remaining work in the project in the OLAP cubes.  Remember that project information does not get into an OLAP cube until the PM publishes the project and then the OLAP cubes rebuild.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, July 11, 2012 3:57 PM
    Moderator
  • Thanks for the response.  We have tried that it is still not pushing the actuals to the cube.

    Any other ideas?

    Wednesday, July 11, 2012 4:49 PM
  • Hi

    It could be problem with synchronization to reporting database. try to rebuild reporting database a then rebuild your OLAP.
    To rebuild report DB, take an Administrative Backup of the Enterprise Custom Fields, then perform an Administrative
    Restore.  This will trigger a Reporting Database rebuild. It can take around 30 minutes so, be patient when you check project queues and one job will be sleeping for a longer time.

    tomas

    Wednesday, July 11, 2012 7:36 PM
  • Is your system set to accept updates from PWA only? Once you take a project off the server, it breaks the connection between the project and the timesheet because the GUIDs change.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG


    Thursday, July 12, 2012 9:48 AM
    Moderator