Oracle P6 Database for Baseline Dates and Primary Baseline Dates and Durations

[Taffalaffa]

Hi.  I need help figuring out how to get my project baseline dates and primary baseline dates.  My Power BI is connected to my P6 database and there are a number of dates avail but none of the ones I am seeing reference the project baseline or the primary, secondary or tertieray baseline dates / durations.  Does anyone know how I can get those dates / durations?

[skhot]

Hello, 

Have you found any solution to this? I am also looking to pull baseline data from database but not sure which fields to look for?

[Taffalaffa]

It is super hard to find info on this.  To link project baseline and baseline tasks use the following:
LEFT JOIN DBO.PROJECT BLPROJECT ON BLPROJECT.PROJ_ID = PROJECT.SUM_BASE_PROJ_ID
LEFT JOIN DBO.TASK BLTASK ON BLTASK.PROJ_ID = BLPROJECT.PROJ_ID AND BLTASK.TASK_CODE = TASK.TASK_CODE 

[v-xiaotang]

Hi @Taffalaffa 

not expert with Oracle, do project baseline dates and primary baseline dates really exist in the database data?

FYI:

https://community.powerbi.com/t5/Desktop/Baseline-vs-Actual/m-p/664740

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.