none
Non -Baseline task Indicators/view in project server 2010 RRS feed

  • Question

  • Hi,

    We have removed the baseline permission for Project Managers, only PMO is doing that job. But even after baselining Project Managers can add new task. We need to track this. I need to create a indicator or view showing only the task which are not baselined. 

    I have created a formula like If ProjDateValue([Baseline Finish]) = Null then No Baseline else Baseline Set. It is working for some task and for some other showing wrong info. 

    Can someone please help.


    Thanks & Regards, Benno
    Monday, May 30, 2011 4:18 PM

Answers

All replies

  • what formula are you using?
    Monday, May 30, 2011 5:21 PM
  • This is the formula we are using  IIf(ProjDateValue([Baseline Finish]) = 4294967295, "No Baseline", "Baseline Set")
    Thanks & Regards, Benno
    Monday, May 30, 2011 7:00 PM
  • Hi Benno,

    try one of these:

    • [Baseline Finish] = ProjDateValue(ʺNAʺ) in an pure English environment or
    • [Baseline Finish] = 4294967295 in a multi-language environment.

    ProjDateValue([Baseline Finish]) is never NULL, but either a date or "NV".

    Hope that helps!
    Barbara

    Monday, May 30, 2011 7:05 PM
    Moderator
  • Hi Benno,

    you had been faster than me. Your formula should work (and it does in my environment). Have you tried a recalculation? What do you mean with "It is working for some task and for some other showing wrong info."?

    Regards
    Barbara

    Monday, May 30, 2011 7:13 PM
    Moderator
  • Hi Barbara,

    I have implemented the formula and it worked on some task that it is showing that there is baseline task or not. But in some other task it is showing there is no baseline even if we have baselined the task at for my wonder i have done baselining all at once. Even recalculate is not solving this issue.

    I guess in 2010 formulas are not getting updated properly.

    I have case in the same project server, an indicator is showing different colors for same outcome. :(

     


    Thanks & Regards, Benno
    Tuesday, May 31, 2011 6:47 AM
  • Hi Benno,

    do you see the correct values for these tasks if you add "Baseline Finish" to a view? Is it possible that they are manually scheduled without a finish date?

    Regards
    Barbara

    Tuesday, May 31, 2011 7:07 AM
    Moderator
  • Hi Barbara,

    Yes i can see the values are present in baseline finish. All the task are auto scheduled and properly linked, even the dates are corrected. The project plan is prefect in format and design.

    Barbara one more question is these changes are reflecting for you in Schedule PDP or only in project professional?? I guess you are trying this.


    Thanks & Regards, Benno
    Tuesday, May 31, 2011 9:00 AM
  • Hi Benny,

    yes, you are right . I tried in client. I did now some other tests in Schedule PDP and can't reproduce your issue. Do yoe see these values after publishing in Project Professional and are the gone after editing in Project Web App. Or are they never displayed correctly?

    Regards
    Barbara

    Tuesday, May 31, 2011 11:50 AM
    Moderator
  • Hi Benno,

    my reason for asking if you are editing your project in PWA was mainly caused by Gary#S comment some time ago, that PWA doesn't understand ProjDateValue() Function (http://social.technet.microsoft.com/Forums/en-us/projectserver2010general/thread/1ae8ed20-89da-43c2-932b-d2ce8fc9de75). But this could only be the case if you open your project for editing - from my understanding.

    I have just tried "IIf([Baseline Finish] = 4294967295, "No Baseline", "Baseline Set")". It does work for me, but since I don't see your issue at all, it's no very meaningful ....

    Regards
    Barbara

    Tuesday, May 31, 2011 1:14 PM
    Moderator