RES27 - Resource Time Analysis
- Last updated
- Save as PDF
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
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:
|
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;
|
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 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. |