Resource Usage Report

Întrebare

25 iunie 2012 21:29

0

Hi All

I am trying to build a resource report, which displays resource usage by month. So the report needs to show rows with the resource names, the columns which are the months (e.g Jan 12, Feb 12, Mar 12 etc etc)

As well as this we want to format the cells to say if its 100% its red, or 80% amber etc.

But first things first I guess, I was going to go to the reporting db and write a query. But I cannot figure out what to put together. Can anyone help with a query, to get me started?
- Mesaj
- Citare

Toate mesajele

25 iunie 2012 23:05

Moderator

0

Hi Project Learner,

There are several options you have. if you wish to report against work and cost you can utilise the olap cubes. As part of your "Pivot table" report utilsing the OLAP cubes you can also apply conditional formating simply using Excel. I can imagine that this will do the trick for you.

Hope htis helps
Marc Soester [MVP] http://marcsoester.blogspot.com
- Mesaj
- Citare
26 iunie 2012 05:30

0
Hi Project Learner--

Another alternate, I would suggest to use the Resource Allocation SSRS report from project server 2007 report pack 2 which works with Project Server 2010 with minor changes. (see the screenshot)
http://archive.msdn.microsoft.com/EPMReportPack

Hope this helps.

If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
- Editat de Amit Khare - Project Management Consultant 26 iunie 2012 05:30
- Mesaj
- Citare
27 iunie 2012 14:09

0

Can you change the timescale on the right to give the same view as the report usage view in MS Project? i.e. per days, weeks, months etc.
- Mesaj
- Citare
27 iunie 2012 22:27

0

Hi

Thanks for the replies - ideally we need % rather than hours with the months showing across the report

Sorry bit lost - I have tried to write a SQL query but cannot get the right number out

Any more advice thankfully recieved
- Mesaj
- Citare
4 iulie 2012 11:02

0

Hi can anyone advise?
- Mesaj
- Citare
9 iulie 2012 07:03

0
It sounds like a better fit for the AssignmentTimePhased cube in OLAP. Have you attempted to write this report using the default Excel Template for that cube? Based on the brief description, this could be a less than 5 minute effort using OLAP.

I've written queries like this before, but it's not for the faint of heart and it requires custom indices. Primarily, because it has to go against the ByDay tables.

For rollup reporting, OLAP is usually a better answer.

Treb Gatte
- Propus ca răspuns de Brian Smith - MSFTMicrosoft Employee, Moderator 9 iulie 2012 15:19
- Mesaj
- Citare
2 septembrie 2012 13:34

0

Hi,

I am using MS Project 2007 standard and have the same request of generating a graphical report based on the timescale table in the Resource Usage View. In this case i am using the Master project Plan (i have 5 projects embedded) and the intention is to present a report to the top management as to when the resources would be free.

thanks

Robert.

Robert Poddar
- Mesaj
- Citare
2 septembrie 2012 22:42

Moderator

0

Robert, have you tried to generate the report using the visual report capability? I can imagine that this could work for you
Marc Soester [MVP] http://marcsoester.blogspot.com
- Mesaj
- Citare
4 septembrie 2012 05:30

0

Robert,

Try this workaround:

1. Goto Report menu. Click on Visual reports.
2. Select Resource Usage tab. Select Resource Work Availability Report. From Select level of usage data to include in the report, select weeks. Click View.
3. In Excel, goto Resource usage sheet, click inside any cell of the pivot table. In Pivot table field list displayed in the right side, select Resources field checkbox.

Please let me know if this workaround helps.

Thanks and Regards, Roopkumar Kamat (MCITP)
- Mesaj
- Citare