S
Solveig
A question from Norway!
I work as a project planner for an organization that has a dozen project and
most of the resources work on more than one project in the same week.
I have one Project 2007 plan for each project and have assigned generic
resources to all plans. I've also generated one Local Resource Usage Cube for
each project containg the Work, Actual Work, Start and Finish fields.
In Excel 2007 I connect to Local Resource Usage Cubes and collects the
information with cubeformulas. Everything is working fine and I manage to get
custom built graphical reports displaying the overall resourse usage and
capacity at a generic level in my organization.
When I make any changes to the plan I just overwrite the existing cube. This
gives me a "somewhat" dynamical report.
I only have one problem: For each project the hours/data that is displayed
in the project plan for instance week 17 is displayed as week 15 in the
cubes/cubeformulas. Does anyone no why? Or any solution to this other than
being aware of the problem and manualy change this in the graphs?
Solveig
I work as a project planner for an organization that has a dozen project and
most of the resources work on more than one project in the same week.
I have one Project 2007 plan for each project and have assigned generic
resources to all plans. I've also generated one Local Resource Usage Cube for
each project containg the Work, Actual Work, Start and Finish fields.
In Excel 2007 I connect to Local Resource Usage Cubes and collects the
information with cubeformulas. Everything is working fine and I manage to get
custom built graphical reports displaying the overall resourse usage and
capacity at a generic level in my organization.
When I make any changes to the plan I just overwrite the existing cube. This
gives me a "somewhat" dynamical report.
I only have one problem: For each project the hours/data that is displayed
in the project plan for instance week 17 is displayed as week 15 in the
cubes/cubeformulas. Does anyone no why? Or any solution to this other than
being aware of the problem and manualy change this in the graphs?
Solveig