H
Hernandezz
Hi,
In my company we use EPM 2007 since we have a lot resources and
projects.
One of the most important functionality for developing Projects is to
prevent the over allocation of the resources in several projects.
In the PWA it is possible to generate a report for this. However the
information is not in real time and therefore it may not be correct,
even if the report cube runs every hour.
No Project professional na vista Resource Usage, existe o campo com a
informação de outros projectos "Other projects and commitments" mas
que não me dá as horas reais se não tiver todos os projectos abertos.
A Microsoft disse que era uma limitação do project.
In Project Professional, Resource Usage view exists a field with the
Information from other projects "Other projects and commitments" but
That gives me the time not real if you do not have all the projects
open.
Microsoft said it is a limitation of the project.
The solution I found for this was to create a macro with VBA. Every
time the project is saved, the macro saves the data, work and actual
work by resource, day, project etc, in the BD created by me. To read
the macro I go directly to the VB and the availability is in real time
and correct .
This week I detected a problem with my macro and why? For example when
I have two projects opened such as the project professional, the
Resources Usage view gives me the work and actual work but this is the
sum of two work projects, hence, my results are not correct anymore.
What would be your suggestion to overcome this microsoft limitation?
And as for the macro, is there a way to differentiate the tasks only
for the project that is opened?
In my company we use EPM 2007 since we have a lot resources and
projects.
One of the most important functionality for developing Projects is to
prevent the over allocation of the resources in several projects.
In the PWA it is possible to generate a report for this. However the
information is not in real time and therefore it may not be correct,
even if the report cube runs every hour.
No Project professional na vista Resource Usage, existe o campo com a
informação de outros projectos "Other projects and commitments" mas
que não me dá as horas reais se não tiver todos os projectos abertos.
A Microsoft disse que era uma limitação do project.
In Project Professional, Resource Usage view exists a field with the
Information from other projects "Other projects and commitments" but
That gives me the time not real if you do not have all the projects
open.
Microsoft said it is a limitation of the project.
The solution I found for this was to create a macro with VBA. Every
time the project is saved, the macro saves the data, work and actual
work by resource, day, project etc, in the BD created by me. To read
the macro I go directly to the VB and the availability is in real time
and correct .
This week I detected a problem with my macro and why? For example when
I have two projects opened such as the project professional, the
Resources Usage view gives me the work and actual work but this is the
sum of two work projects, hence, my results are not correct anymore.
What would be your suggestion to overcome this microsoft limitation?
And as for the macro, is there a way to differentiate the tasks only
for the project that is opened?