Clarity

  • 1.  Issue in the comparison of baseline

    Posted Jul 18, 2018 04:46 PM
      |   view attached

    Hi,

     

    I have some difficulties visualizing the baseline dates when a baseline previous to the last one is placed as current. Place images of the steps that I followed in a PowerPoint file that I attached.

     

    Thank you so much for your help.

     

    Cira

    Attachment(s)

    pptx
    20180718 Issue with BL.pptx   479 KB 1 version


  • 2.  Re: Issue in the comparison of baseline
    Best Answer

    Posted Jul 19, 2018 02:58 AM

    Query the baseline details to see that the detail dates are really there.



  • 3.  Re: Issue in the comparison of baseline

    Posted Jul 19, 2018 03:44 AM

    Hi Cira,

     

    I also Agree with Martti, checking the Database tables will be best option if you have any doubts on this. PRJ_BASELINE_DETAILS and PFM_BASELINE_DETAILS will be giving you the information regarding the same. 

     

    Cheers!



  • 4.  Re: Issue in the comparison of baseline

    Posted Jul 19, 2018 09:54 AM

    Thank you Urmas and Abhisek,

     

    Do you have some example of this query?

     

    Regards,

     

    Cira



  • 5.  Re: Issue in the comparison of baseline

    Posted Jul 19, 2018 10:26 AM

    Suppose you want to get Baseline Start Date of a task for multiple baselines. This query can be used for the same: 

     

    select object_type,object_id, start_date, finish_date 
    from prj_baseline_details 
    where baseline_id = (select ID from prj_baselines where object_type = 'PROJECT' and name = 'Abhisek_Baseline1' <Your baseline Name> and project_id = 5002073 <your project ID> ) 
    and object_type = 'TASK'

     

    Hope that helps you to get an idea. 



  • 6.  Re: Issue in the comparison of baseline

    Posted Jul 19, 2018 12:40 PM

    Thank you so much

     

    Cira