PWA 2007 - Refresh Project Enterprise Fields Options

[Vit @ OZ]

Hi all!!!

I have created a custom enterprise project field in Project Server
2007.

The calculation is the following:

Schedule (Project Level)
IIf([Enterprise Number1]>=0,"On Schedule",IIf([Enterprise Number1]<-5,"Late
by more than 5 days","Late"))

Enterprise Number 1(Days Slippage)
IIf([% Complete]=100,"0",(ProjDateDiff([Current
Date],[Finish],"Standard")/480))

On Shedule = green light
Late by more than 5 days = yellow light
Late = red light

I have added my graphical indicator to a view in Project Web Access
(PWA) and then republished all Projects. This works and all Projects
are given a green light. However, after a week of not updating
Projects, the graphical indicator is not updated in my PWA view - all
Projects still have the same light indicator.

I thought that enterprise fields are now calculated in Project Server
not Project Professional. Can someone confirm this and provide some
advice or have I got this all wrong?


I am using Project Server 2007 and Project Professional 2007 (what about on
the 2003 version???)

is there a way to update the indicato by sql/macro/vba or anything else???

thanks to everybody.

Vit

 

[Andrew Jacks]

Vit,

I'm sure that Project Sever Does not perform the project calculations and
that the only way to get your values re-calculated is to re-publish the
projects.

Have you tried publishing one of the Project to see what happens?

 

[Jack Dahlgren]

Your expectations are correct, but the customized field indicators in Project
2007 are broken. This is a known bug and I believe that Microsoft is working
on fixing it.

The only way to make it work the way you want is to only update custom
fields from Project Professional and to publish the project plans.

Further, I would recommend against using custom fields as inputs to other
custom fields. I have observed issues in doing this as the order of
calculation is not always correct. So, modify any custom field so that it is
not dependent on a calculation in another field.

-Jack Dahlgren

 

[MLH]

Hi, i recently deleted some enterprise fields and as a result the rest of the
project enterprise fields were broken.
I already confirmed that the current custom fields are not dependent of the
deleted custom fields but the problem persist.

any idea?
thanks in advance

Your expectations are correct, but the customized field indicators in Project
2007 are broken. This is a known bug and I believe that Microsoft is working
on fixing it.

The only way to make it work the way you want is to only update custom
fields from Project Professional and to publish the project plans.

Further, I would recommend against using custom fields as inputs to other
custom fields. I have observed issues in doing this as the order of
calculation is not always correct. So, modify any custom field so that it is
not dependent on a calculation in another field.

-Jack Dahlgren

Hi all!!!

I have created a custom enterprise project field in Project Server
2007.

The calculation is the following:

Schedule (Project Level)
IIf([Enterprise Number1]>=0,"On Schedule",IIf([Enterprise Number1]<-5,"Late
by more than 5 days","Late"))

Enterprise Number 1(Days Slippage)
IIf([% Complete]=100,"0",(ProjDateDiff([Current
Date],[Finish],"Standard")/480))

On Shedule = green light
Late by more than 5 days = yellow light
Late = red light

I have added my graphical indicator to a view in Project Web Access
(PWA) and then republished all Projects. This works and all Projects
are given a green light. However, after a week of not updating
Projects, the graphical indicator is not updated in my PWA view - all
Projects still have the same light indicator.

I thought that enterprise fields are now calculated in Project Server
not Project Professional. Can someone confirm this and provide some
advice or have I got this all wrong?


I am using Project Server 2007 and Project Professional 2007 (what about on
the 2003 version???)

is there a way to update the indicato by sql/macro/vba or anything else???

thanks to everybody.

Vit