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,
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
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