L
Lene
We have a global resource pool with approx. 1000 resources.
All internal resources are added to the resource pool in the same way
by integration to another LOB application.
No resources have limitations in available from available to.
Some resources have Units limited, but most of these show correct
availability
When checking the global resource pool all resources show correct
availability.
But when using PWA and checking resource availability in the "Analyze
Resources in Portfolio Analyzer", some resources show wrong
availability. E.g. The resource Ole Brok Petersen shows wrong
availability, (34,5 hours in 2005 where as several others show 1756,
which is correct) despite that his availability is unlimited.
Checking PWA is shows that Ole only has 34,4 hours availability and
only in 2005 - but that is not correct. Ant the same goes for several
other resources.
We have checked several tables in the SQL server and it seems that the
table
MSP_Ressource for some reason has a problem with the RES_ID.
This example shows that the same RES_ID is allocated to two different
resources
We have crosschecked with several other tables and there seem to be
something wrong, only I cant figure it out.
Can anyone help me???
I have several screenshots, but I can´t apply them to this site
This example is made from real values in different tables and how is it
possible to have the same RES_ID for two different ressources
Res name RES_ID RES_UID RES_EUID
A 13 752 752
B 251 251 251
C 13 13 13
All internal resources are added to the resource pool in the same way
by integration to another LOB application.
No resources have limitations in available from available to.
Some resources have Units limited, but most of these show correct
availability
When checking the global resource pool all resources show correct
availability.
But when using PWA and checking resource availability in the "Analyze
Resources in Portfolio Analyzer", some resources show wrong
availability. E.g. The resource Ole Brok Petersen shows wrong
availability, (34,5 hours in 2005 where as several others show 1756,
which is correct) despite that his availability is unlimited.
Checking PWA is shows that Ole only has 34,4 hours availability and
only in 2005 - but that is not correct. Ant the same goes for several
other resources.
We have checked several tables in the SQL server and it seems that the
table
MSP_Ressource for some reason has a problem with the RES_ID.
This example shows that the same RES_ID is allocated to two different
resources
We have crosschecked with several other tables and there seem to be
something wrong, only I cant figure it out.
Can anyone help me???
I have several screenshots, but I can´t apply them to this site
This example is made from real values in different tables and how is it
possible to have the same RES_ID for two different ressources
Res name RES_ID RES_UID RES_EUID
A 13 752 752
B 251 251 251
C 13 13 13