Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P6 Cost data fields?

6 replies [Last post]
Thu, 2010-06-24 03:55
Martin Corkill
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 4 Jul 2003
Posts: 25
Groups: None
Does anyone know where P6 hides the cost information? I’m looking to use Access to build s-curves, but can’t find the cost data source fields anywhere? What does P6 use to create its ’Activity Usage’ view from?
Top

Replies

Thu, 2010-06-24 05:42
#1
Martin Corkill
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 4 Jul 2003
Posts: 25
Groups: None
Cancel that - I’ve found it, thanks for the help Rodel.
Top
Thu, 2010-06-24 05:26
#2
Martin Corkill
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 4 Jul 2003
Posts: 25
Groups: None
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 it’s empty?
Top
Thu, 2010-06-24 05:05
#3
Rodel Marasigan
User offline. Last seen 1 hour 40 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
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.
Top
Thu, 2010-06-24 04:34
#4
Martin Corkill
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 4 Jul 2003
Posts: 25
Groups: None
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.
Top
Thu, 2010-06-24 04:25
#5
Martin Corkill
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 4 Jul 2003
Posts: 25
Groups: None
That’s 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?
Top
Thu, 2010-06-24 04:21
#6
Erickson Tria
User offline. Last seen 2 years 6 weeks ago. Offline
Joined: 12 Jul 2006
Posts: 11
Groups: GPC Qatar, Pinoy Planning Planet Community
When you’ve already loaded the resources on the activities you can view them on assignment, resource table or profile. Use the icons and explore.
Top