Skip to main content
Planview Customer Success Center

RES27 - Resource Time Analysis

Overview

Resource portfolio based report that provides an analysis of timesheet actuals. The report provides:

  • Work (project) and standard activity split
  • Work analysis by any activity attribute, for example billable/non-billable
  • Standard Activity analysis by type
  • Drillable table to detailed activities and timesheet hours

           

clipboard_e2aad163286a06417200211e8c9d480a9.png

RES27 Resource Time Analysis example

           

           

Business Outcomes

  • Identification and analysis of non-productive time and absences, driving improved resource utilization.
  • Analysis of margin impacting non-productive work.

           

           

Supporting Capabilities

  • Time Reporting
  • Other Planned Work

           

           

Business Rules

This report will only contain time analysis data from progressed actual effort.

           

           

Administration: User Parameter Configuration

Parameters Description Configuration Options Default/Example Settings
Work Slicer Attribute to use to slice the time spent on projects Could be any of the project alternate structure (+ WBS levels) Slicer1=wbs709_plan
Standard Activity Slicer Attribute to use to slice the time spent on standard activities 2 possible values:
  • Utilization Flag (UtlFlag)
  • Activity (StdAct)
Slicer2=UtlFlag
Time Slice Granularity to use in the trend charts Week or Month Breakdown_by=month
Effort Unit of Measure Unit to use to display actual effort Hours or Days Effort_unit=hour
Start/End Date Ability to select range of data returned N/A Defaults cant be set

           

           

Administration: Hidden Parameter Configuration

Parameters Description Configuration Options Default/Example Settings
Table Columns Four configurable columns are available;
  • Two resource attributes can be displayed after the resource name column
  • Two work attributes can be displayed after the activity/task column (not available for standard activities)
Columns display in the order they appear in the configuration structure Obs_lev_4_res
Cbs1_res
work_description
wbs24_plan
Horizon start parameter Ability to configure horizon start For the default start date the horizon_start parameter is taken into account along with the timeslice one. For instance if their respective values is -10 and month, the default start date will be Current Date – 10 Months Horizon_start=-10
Horizon finish parameter Ability to configure horizon finish For the default end date the horizon_finish parameter is taken into account along with the timeslice one. For instance if their respective values is -1 and month, the default end date will be Current Date – 1 Month Horizon_finish=0
Report Title Configurable report title that appears at the top of the report. If a longer report title is required, then create additional report_title=xxx entries and these will be concatenated together based on the order in which they are listed in the configuration structure. report_title=Resource Time Analysis
Detail Table Layout Allows user to control the layout of the detail table

Grouped/Pivot - shows the data grouped and formatted with time period columns
Plain/Excel - flat table optimized for analysis in an Excel export

table_layout=grouped|plain

table_layout=grouped

           

           

Additional Information

Only progressed timesheets are taken into account.

           

           

Technical/Database Information

Report (RDL) Location …/Reports/RPM_PROD/Resource_RPM/RPM-RES27/RPM-RES27_v2.rdl
Database

This report uses the transactional database and uses the daily tables. Therefore data currency will be dependent, for some assignment types, on a refresh of the daily tables.

Refer to the Administer Rates and Daily Tables (Introduction) topic for more details.