Clarity

  • 1.  Create Baseline with XOG - BAC, BAC Cost, Cost fields

    Posted Jul 21, 2016 03:32 AM


    Hi all,

     

    we have a request to Create baseline with specific name and id, so we have to create it by XOG in GEL script. It's not a problem with one exception. The exception is BAC, BAC Cost and Cost fields, which are not filled.

     

    I know how to add them by XOG, but I am not able to find these data in DB to put them to the XOG message.

     

    Does anyone know how to query these data from DB?

     

    Thank you all in advance,

    Martin



  • 2.  Re: Create Baseline with XOG - BAC, BAC Cost, Cost fields
    Best Answer

    Posted Apr 17, 2018 01:03 PM

    Martin,

    The BAC and other cost field are the virtual field of the baseline object. They are not stored directly in the db. To calculate them we need to do some calculation on other fields like BAC is calculated from (Sum of all the assignment level Actual Cost values for the project) + ETC (Cost) at the time the baseline is recorded. This will include future posted actual costs. 

     

    You can refer the below link to know how to calculate other cost fields:

     

    CA Clarity Tuesday Tip: Earned Value Calculations



  • 3.  Re: Create Baseline with XOG - BAC, BAC Cost, Cost fields

    Posted Oct 30, 2018 01:40 PM

    Hi Martin,

     

    We want to create automatic baselines for some projects with a GEL Script using XOG, I can create baseline for "pROJECT", "TEAM" and "TASK" but not for "ASSIGNMENT" in the PRJ_BASELINE_DETAILS table, can you provide me a XOG example for creating baselines ?

     

    Thank you for your help, Patrice