Is there any way to get the latest baseline start date directly?

All replies

• 

  

  0

  Sign in to vote

  hi there,

  You can get this from the PWA Reporting database for the Project Baseline information look in the MSP_EPMProject_Userview or for the task baseline data look in the MSP_EPMTask_Userview.

  Hope this helps.

  Thanks

  Paul

   

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com

  Monday, September 5, 2011 12:20 PM
• 

  

  0

  Sign in to vote

  Hi Anuranjan,

  in the scope of Project Client and within a single project plan you can group your tasks using a field like "Baseline Start1".

  Best Regards

  Philipp

  Monday, September 5, 2011 12:29 PM
• 

  

  1

  Sign in to vote

  Hi ,

   

  Is there any way we can get this by  formula on PDP pages

  ---

  Vipin Upadhyay AonHewitt

  Tuesday, September 6, 2011 9:22 AM
• 

  

  0

  Sign in to vote

  Hi Vipin

  Why do you need it using formula on PDP, could you elaborate a more on the requirement ?

  ---

  Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com

  Tuesday, September 6, 2011 9:37 AM
• 

  

  1

  Sign in to vote

  Hi Sunil Sir,

  Actully we are calculating some budget value which will be displayed  on the PDP page and that  is getting calculated from latest baseline cost .

  So better though to create one project level  custom filed(Formula Based) and display it on PDP page.

  I think i have explained enough if you required anything else in this please revert.

  Tx in Advance

  Vipin Upadhyay

  ---

  Vipin Upadhyay AonHewitt

  • Marked as answer by Anuranjan Prasad Tuesday, September 13, 2011 3:14 AM

  Friday, September 9, 2011 11:00 AM
• 

  

  0

  Sign in to vote

  Still not sure I follow, but if properly done, the Last Saved Baseline should

  always be Baseline0, with each Baseline saved also to Baseline1/2/3/x for

  posterity.

   

  So you can pull the Baseline0 Finish date for a specific task and that should

  always be the last one.

   

  If you just want to roll up the latest Baseline Finish date in a collection

  of tasks, I would create a custom Date field with the formula =[Baseline

  Finish], then set it to Rollup to summary bars as the Maximum.  On the Project

  level, create a new Project level date field with the formula "=[Date]" where

  [Date] is the first field you created.

   

   

  ---

  Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

  Friday, September 9, 2011 1:53 PM
• 

  

  1

  Sign in to vote

  Hi All,

  Create a custom field with entity type as 'Project', Type 'date' and paste the below mentioned formula. This works for me :)

  IIf(Not IsNull([Baseline9 Finish]), [Baseline9 Finish], IIf(Not IsNull([Baseline8 Finish]), [Baseline8 Finish], IIf(Not IsNull([Baseline7 Finish]), [Baseline7 Finish], IIf(Not IsNull([Baseline6 Finish]), [Baseline6 Finish], IIf(Not IsNull([Baseline5 Finish]), [Baseline5 Finish], IIf(Not IsNull([Baseline4 Finish]), [Baseline4 Finish], IIf(Not IsNull([Baseline3 Finish]), [Baseline3 Finish], IIf(Not IsNull([Baseline2 Finish]), [Baseline2 Finish], IIf(Not IsNull([Baseline1 Finish]), [Baseline1 Finish], IIf(Not IsNull([Baseline Finish]), [Baseline Finish], ""))))))))))

  Thanks

  Anuranjan Prasad

   

  • Proposed as answer by Vipin Upadhyay Monday, September 12, 2011 3:21 PM
  • Marked as answer by Anuranjan Prasad Tuesday, September 13, 2011 3:14 AM

  Monday, September 12, 2011 1:32 PM