Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-04-2013, 06:38 PM
seanpears99 seanpears99 is offline Portfolio Analyzer Cube - Cost Resource Question Windows 7 64bit Portfolio Analyzer Cube - Cost Resource Question Office 2007
Novice
Portfolio Analyzer Cube - Cost Resource Question
 
Join Date: Oct 2011
Posts: 12
seanpears99 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-05-2013, 11:19 AM
JulieS JulieS is offline Portfolio Analyzer Cube - Cost Resource Question Windows 7 64bit Portfolio Analyzer Cube - Cost Resource Question Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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
Reply With Quote
  #3  
Old 03-07-2013, 06:59 PM
seanpears99 seanpears99 is offline Portfolio Analyzer Cube - Cost Resource Question Windows 7 64bit Portfolio Analyzer Cube - Cost Resource Question Office 2007
Novice
Portfolio Analyzer Cube - Cost Resource Question
 
Join Date: Oct 2011
Posts: 12
seanpears99 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Portfolio Analyzer Cube - Cost Resource Question 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
Portfolio Analyzer Cube - Cost Resource Question Common mailbox analyzer/statistics NoStr0m0 Outlook 3 09-23-2011 05:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft