#1
|
|||
|
|||
Portfolio Analyzer Cube - Cost Resource Question
Hi
I have been amending our current project template to allow easier updating methods for our PM community. The current set up of our template has been desigined to assist in the generation of our fortnightly status reports which are generated into a BI SQL Report. My question, one of the sections I need to amend is a section based around Stage Budgets, this section previously had 6 tasks, Stage 1 - 6 and 4 and cost resources were assigned to each task and this section was maintained outside of the normal schedule activites (i.e. at the top of the template away from the main body). In here the PMs would add Opex and Capex costs, publish and then regenerated the status report following a cube rebuild. My change was to remove this section, and allocate the cost resources to the actual Stage 1-6 of the schedule, each stage incorporating the rest of the delivery tasks for each stage. i.e. I was now allocating the cost resources to the summary activities of each stage. Now after I publish and rebuild, the summary level cost information is not contained within the cube, can someone tell if it is ok to allocate cost resources to summary activities (this is only to subtantiate the report which aggregates the data over years based upon the duration of the summary activity). If so, where can I ensure that the summary level info is included in the cube (or is this not possible?) Thanks Sean |
#2
|
|||
|
|||
Hi Sean,
I do not use Project Server - and I am assuming you do from your use of the word "publish." However, in the Pro client, I cannot see what you report. When I assign Cost resources to detail and summary tasks, the data in the Cash Flow report is correct. The Cash Flow report is based upon the Task Usage cube. The Earned Value over time report does not work at all - but it hasn't ever worked for Cost resources. Which cube are you trying to read? This question may be best posted to the Microsoft Forum for Project Server: http://social.technet.microsoft.com/...eneral/threads If you post there - please explicitly state what version of Project and Server you are using. Julie |
#3
|
|||
|
|||
Hi Julie
I am useing Project Pro 2010 and Server. I have since found that the cube only stores task info and not summary related so its no good to me. Thanks for your help. Sean |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cost loading of non scope items | ketanco | Project | 3 | 08-24-2012 05:55 AM |
Which column shows just labor cost? | ketanco | Project | 9 | 06-20-2012 02:19 PM |
How to rename cost column | ketanco | Project | 3 | 06-15-2012 03:06 PM |
entering values for a cost type resource | ketanco | Project | 3 | 12-26-2011 09:25 AM |
Common mailbox analyzer/statistics | NoStr0m0 | Outlook | 3 | 09-23-2011 05:22 AM |