This report shows resources assigned to projects and tasks including actual hours and ETC hours.
Run this report if you work with resources.
Note: See the Resource Management User Guide for more information.
Indicates how the information is to be grouped and presented on the report. Select an option from the drop-down to show how you want the information grouped.
Indicates whether the weekly or monthly period type will be reported.
Indicates the project or projects on which data is reported.
Indicates the name of the resources that the report will provide data for. Click the Browse icon and select names from the list that appears.
Identifies the Resource manager or managers whose data displays in the report. Click the Browse icon to select names.
Indicates the OBS unit that the report will be filtered by. Click the Browse icon and select the OBS from the list that appears.
Defines the start date of the report. To select a specific day, select the Specific Date option and type a date in the text field in the mm/dd/yyyy format or click the Date Picker to select a day from the calendar that displays. To select a relative date such as Start of Next Month, select the Relative Date option and select the relative date that applies from the drop-down list.
Indicates the type of hours to be included on the report (allocated or assigned). You can select multiple items for this field.
The report contains a graph that shows the assigned hours for resources on the report compared to the allocated hours for resources.
Displays the hours charged to the project for the time period selected.
nbi_project_res_task_facts.actual_qty
Displays the assigned hours.
This is a calculated field. For more information, see the report's SQL statement.
Displays the end date for the reporting period.
prtask.finish
Displays the number of hours estimated to complete the task.
nbi_project_res_task_facts.etc_qty
Displays the name of project being reported on.
nbi_project_current_facts. project_name
Displays the resource being reported on.
nbi_resource_facts.full_name
Displays the start date for the reporting period.
prtask.prstart
Displays a project task being reported on.
prtask.prname
Displays the type of hours. The value is either Allocated or Assigned.
This value is not stored in a database table and column. It is passed as a parameter.
Displays the percentage of difference between the hours allocated for a project and the hours assigned to resources.
Calculation: ((Assigned Hours - Allocated Hours)/Allocated Hours).
Database Tables and Columns:
This is a calculated field. For more information, see the report's SQL statement.
This report displays the following information:
Run this report if you work with resources.
Note: See the Resource Management User Guide for more information.
Indicates whether the weekly or monthly period type will be reported.
Identifies the Resource manager or managers whose data displays in the report. Click the Browse icon to select names.
Indicates the OBS unit that the report will be filtered by. Click the Browse icon and select the OBS from the list that appears.
Indicates the role or roles to be included on the report. Click the Browse icon and select roles.
Defines the start date of the report. To select a specific day, select the Specific Date option and type a date in the text field in the mm/dd/yyyy format or click the Date Picker to select a day from the calendar that displays. To select a relative date such as Start of Next Month, select the Relative Date option and select the relative date that applies from the drop-down list.
Displays the percentage of the capacity hours that have been allocated.
prj_blb_slices.slice for request_name = dailyresourcealloccurve.
Displays the available capacity remaining.
Calculation: (Capacity Hours - Allocation Hours).
This is a calculated field. For more information, see the report's SQL statement.
Displays the capacity available in hours.
prj_blb_slices.slice for request_name = dailyresourceavailcurve.
Displays the name of the investment being reported on.
prteam.prprojectid
Displays the primary role being reported on.
srm_resources.last_name where prprimaryroleid of the resource name equals srm_resources.id.
Displays the organizational breakdown structure for the projects on the report.
nbi_dim_obs.obs_unit_id
Displays the resource being reported on.
nbi_resource_facts.full_name
| Copyright © 2010 CA. All rights reserved. | Email CA Technologies about this topic |