For Cost and resource assignment TASKRSRC table. All information is there. If you are using SDK you can also use TASK Spread table which can be set date interval by day, week, month or year.
Member for
22 years 3 months
Member for22 years4 months
Submitted by Martin Corkill on Thu, 2010-06-24 05:34
I have chosen "Cost" data, and the "Total" box is ticked
I have ticked Budgeted; Actual and Remaining.
I now have a lovely little graphic showing me bars for each of those, for each time period. I can double-click in there and it pops up with a box showing me Total and Cumulative values for each of those.
My question is - FROM THE DATABASE, WHICH DATA FIELDS ARE P6 USING TO CREATE THIS GRAPH? When I open the database, I can not find "Budgeted Total Cost" or "Cumulative Total Cost" or anything like that.
Member for
22 years 3 months
Member for22 years4 months
Submitted by Martin Corkill on Thu, 2010-06-24 05:25
Member for
22 years 3 monthsRE: P6 Cost data fields?
Cancel that - Ive found it, thanks for the help Rodel.
Member for
22 years 3 monthsRE: P6 Cost data fields?
Rodel,
Thanks for your reply. I am using the SDK and also have an ODBC link via MS Access. When I open the TASKRSRC table in MS Access its empty?
Member for
19 yearsRE: P6 Cost data fields?
Martin,
For Cost and resource assignment TASKRSRC table. All information is there. If you are using SDK you can also use TASK Spread table which can be set date interval by day, week, month or year.
Member for
22 years 3 monthsRE: P6 Cost data fields?
Let me rephrase my question in simpler terms...
I have clicked "Activity Usage Profile"
I have chosen "Cost" data, and the "Total" box is ticked
I have ticked Budgeted; Actual and Remaining.
I now have a lovely little graphic showing me bars for each of those, for each time period. I can double-click in there and it pops up with a box showing me Total and Cumulative values for each of those.
My question is - FROM THE DATABASE, WHICH DATA FIELDS ARE P6 USING TO CREATE THIS GRAPH? When I open the database, I can not find "Budgeted Total Cost" or "Cumulative Total Cost" or anything like that.
Member for
22 years 3 monthsRE: P6 Cost data fields?
Thats not what I was asking. I need to access the data OUTSIDE of P6, using MS ACCESS. I want to know which DATA FIELDS store the cost information.
Anyone?
Member for
19 years 3 monthsRE: P6 Cost data fields?
When youve already loaded the resources on the activities you can view them on assignment, resource table or profile. Use the icons and explore.