Resource Availability Visual Report keeps crashing…how do I get the time-phased info out?

Home Forums Discussion Forum Resource Availability Visual Report keeps crashing…how do I get the time-phased info out?

Viewing 0 reply threads
  • Author
    Posts
    • #5165
      Amina Muhammad
      Keymaster

      Hi all

      I’m using Project Pro (SP1 & Cumulative patches installed; both Office and Project ‘repaired’ after it was a suggested fix) and am trying to pull the Resource Availability Visual Report into excel.

      I am using a Resource Pool with only 50 resources with about 6 plans connected to it. I also have a Master file created with all the .mpp files inserted as a sub-project. I have taken these files off the network and currently have them on a USB stick and access them via a laptop.

      ISSUE #1

      I get the following error FROM EXCEL:

      File system error: An error occurred while opening ‘D:DOCUME~1PKMACCTLocals~1Temp1Visual Reports Temporary Data{acdeafd6-f32c-4192-8d9e-b5ca6ac126a8}ResourceTP.cub’local cube file 

      All other reports can be created, though they are based on a 2003 template.

      I have tried replacing the 2003 template for this report with a 2010 version of the file, but my system simply recreated it and the report still pulls the .xlt file, not the new one.

      ISSUE #2

      In a desperate attempt to get something to work, I disconnected each plan from the Resource Pool and used the Master to create this report and it worked!

      Only problem is I now have duplicate entries for Resources assigned to multiple projects and cannot filter on projects. (I tried a custom field to bring the project names over but all it would return is a NULL value)

      I’ve also noticed this report is basing availability off of Max Units. This is an issue, since I schedule with 100% (or more when it’s a group) Max Units and have a modified Base Calendar. Is there any quick fix to this?

      Thanks in advance for any and all help provided!

      Shelley

Viewing 0 reply threads
  • You must be logged in to reply to this topic.