Data field missing in P3 ?
In the Open Standard
Morph TMember for 20 years 2 months
- Created
- 2
- 4
0
Hi all
I linked excel to P3 using ODBC Btrieve driver, using advanced mode so all data table are load, but I can’t find data field BQWP, and BQWS.
Basically, what I want to do, is having my spreadsheet dynamically link to P3, showing activities grouped by resource and columns BQWS, and BQWP, AQWP.
Ps: I can do that by tool, tabular report, resource. But exporting then coping and posting each time when I update my plan is rather a painful process.
Regards
Morph
I linked excel to P3 using ODBC Btrieve driver, using advanced mode so all data table are load, but I can’t find data field BQWP, and BQWS.
Basically, what I want to do, is having my spreadsheet dynamically link to P3, showing activities grouped by resource and columns BQWS, and BQWP, AQWP.
Ps: I can do that by tool, tabular report, resource. But exporting then coping and posting each time when I update my plan is rather a painful process.
Regards
Morph
2 replies
Oldest first- 0David Kelly ·Morph,
Its a while since I have done this. But if I remember correctly BQWP can only be inferred from the resource table by multiplying the BQ by the percent complete in that table. BQWS is NOT held in the current project, but is calculated on the fly depending on which target project is chosen ( needing two projects connected by ODBC will slow your spreadsheet down to a crawl) and AQWP is just QTYToDate in the resource table.
I wish you luck, Calculating BQWS from a dynamically linked target project sounds too difficult.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?