Tuesday 15 December 2009

What Are My Project Costs by Resource Type for Next Period? Part 2

Refer to earlier post for details on how this information can be delivered via Resource Usage view.

In this post, we will look at how this information can be delivered via Visual Reports.

1) Open existing project from the server.

2) Navigate to Report > Visual Reports and launch the ‘Resource Cost Summary’ Report under ‘Resource Usage’ Tab

EPM2007_VisualReport_0

(click picture to enlarge)

Ensure time period selected is weekly.

EPM2007_VisualReport_1

(click picture to enlarge)

3) Select the Resource Usage Tab in the Excel work-book.

EPM2007_VisualReport_2

4) Update the Fields List for Column, Row and value fields as per example in figure below.

EPM2007_VisualReport_3

(click picture to enlarge)

5) Review the report and adjust/format (for timescales) as necessary.

EPM2007_VisualReport_4

Visual reports provide a powerful way to analyse project data using Microsoft Excel.

No comments:

Post a Comment

Please include your email address with comments.