Clarity

  • 1.  How to get Baseline Start Date of a task for multiple baselines

    Posted Mar 19, 2012 06:26 AM
    Hi,

    We have a need wherein we need to compute the Delay Rate of a Task (Task A), for example:

    Task Name: Task A
    Baseline Start Date of Baseline 1: Jan 1, 2012
    Baseline Start Date of Baseline 2 (current): Jan 10, 2012

    So to compute the Delay Rate of Task A, I need to subtract the 2 dates above. However, in our PRTASK table, the PRBASESTART which stores the baseline start date of a task, only stores the baseline start date of the current baseline. In example above, the PRBASESTART only stores Jan 10, 2012 unless I change the current to Baseline1.

    Do you have any idea on how or where in Clarity tables can I get the Baseline Start Date of Baseline 1 without switching the version of the baseline?

    Thanks a lot.


  • 2.  RE: How to get Baseline Start Date of a task for multiple baselines
    Best Answer

    Posted Mar 19, 2012 08:02 AM
    Yeah the PRTASK details are the "current baseline"...

    ...the history of all the other baselines taken will be in PRJ_BASELINE_DETAILS against an object_type of 'TASK'


  • 3.  RE: How to get Baseline Start Date of a task for multiple baselines

    Posted Mar 19, 2012 09:03 AM
    Thanks Dave! I also looked in PRJ_BASELINE_DETAILS table but my mistake is i only looked for the Project not the object type = task. i will try it tomorrow once i'm back in the office :) thanks!


  • 4.  RE: How to get Baseline Start Date of a task for multiple baselines

    Posted Mar 19, 2012 08:38 AM
    Here is the query I have used, if you wanted to make use...

    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 = 'Baseline1' <Your baseline Name> and project_id = 5002073 <your project ID> )
    and object_type = 'TASK'

    Thanks

    Venky


  • 5.  RE: How to get Baseline Start Date of a task for multiple baselines

    Posted Mar 19, 2012 09:06 AM
    Thanks i_rock for the SQL! :)


  • 6.  RE: How to get Baseline Start Date of a task for multiple baselines

    Posted Mar 19, 2012 12:52 PM
    For tasks you could try to start from

    SELECT inv_investments.name Project
    ,inv_investments.code ProjectCode
    ,PRJ_BASELINES.NAME Baseline
    ,PRJ_BASELINES.CODE BaselineCode
    -- ,PRJ_BASELINE_DETAILS.BASELINE_ID
    ,PRJ_BASELINE_DETAILS.ID BASELINE_DET_ID
    ,PRJ_BASELINE_DETAILS.OBJECT_ID TASKID
    -- ,PRJ_BASELINE_DETAILS.OBJECT_TYPE
    ,PRTASK.PRNAME TASK
    ,PRTASK.PREXTERNALID TASKCODE
    -- ,PRJ_BASELINE_DETAILS.USAGE_SUM
    -- ,PRJ_BASELINE_DETAILS.COST_SUM
    ,PRJ_BASELINE_DETAILS.START_DATE
    /* ,PRJ_BASELINE_DETAILS.FINISH_DATE
    ,PRJ_BASELINE_DETAILS.DURATION
    ,PRJ_BASELINE_DETAILS.PREXTENSION
    ,PRJ_BASELINE_DETAILS.MSP_DIRTY
    ,PRJ_BASELINE_DETAILS.CREATED_DATE
    ,PRJ_BASELINE_DETAILS.CREATED_BY
    ,PRJ_BASELINE_DETAILS.LAST_UPDATED_DATE
    ,PRJ_BASELINE_DETAILS.LAST_UPDATED_BY
    ,PRJ_BASELINE_DETAILS.IS_CURRENT
    ,PRJ_BASELINE_DETAILS.SLICE_STATUS
    ,PRJ_BASELINE_DETAILS.EVM_MR_SUM
    ,PRJ_BASELINE_DETAILS.EVM_UB_SUM
    ,PRJ_BASELINE_DETAILS.EVM_BURDEN_FEE
    ,PRJ_BASELINE_DETAILS.EVM_BURDEN_COM
    ,PRJ_BASELINE_DETAILS.EVM_BURDEN_GA
    ,PRJ_BASELINE_DETAILS.EVM_BURDEN_OVHD */
    FROM c8.niku.PRJ_BASELINE_DETAILS
    ,c8.niku.PRJ_BASELINES
    ,c8.niku.inv_investments
    ,c8.niku.PRTASK
    Where PRJ_BASELINE_DETAILS.BASELINE_ID = PRJ_BASELINES.ID
    AND PRJ_BASELINES.PROJECT_ID = inv_investments.id
    AND PRJ_BASELINE_DETAILS.OBJECT_TYPE = 'TASK'
    AND PRJ_BASELINE_DETAILS.OBJECT_ID= PRTASK.PRID


    Martti K.


  • 7.  RE: How to get Baseline Start Date of a task for multiple baselines

    Posted Mar 19, 2012 09:24 PM
    Thanks another_martink!

    I'm just new in clarity so all the answers given by the three of you here are very helpful :)