Forum Discussion
Helper IOracle P6 Database for Baseline Dates and Primary Baseline Dates and Durations
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?
3 Replies
v-xiaotangCommunity Support
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.
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?
TaffalaffaIt 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