Resource Skills Report

ccppmop1561
The Resource Skills report displays the skills hierarchy with the associated resources at each level in the hierarchy. This report includes the proficiency rating and interest level of each resource for each listed skill. The report also includes a stacked column chart displaying the number of resources by parent skill and employment type.
The following image shows the Resource Skills report:
Image of the Resource Skills report with list and column chart.
Report Prerequisites
Complete the following prerequisites before you run this report:
  • At least one skill must exist (Administration, Data Administration, Skills Hierarchy). The skill must be associated with at least one labor resource. Otherwise, the report displays a message that no results match your criteria.
  • The resource skills in the report depend on the report skills tables. To update these tables, run the Update Report Tables job with the update resource skills index option selected. The report skills tables store the relationships between resource skills and their parent skills. The job supports up to ten levels in the skills hierarchy. Run this job whenever a skill is created, deleted, or renamed. Also run the report when a skill is modified in the skills hierarchy (Administration, Data Administration, Skills Hierarchy). You do not have to run the report after associating skills to resources.
Report Properties
The following values list the report properties:
Name:
Resource Skills
Resource ID:
CSK_RES_Skills
Description:
Resource Management (PMO Accelerator)
Folder:
CA PPM/Reports/Resource Management/Resource Skills
Path:
/ca_ppm/reports/resource_management/CSK_RES_Skills
Data Source:
Clarity PPM
bean datasource
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type
Input Control Name
Input Control Resource ID
Mandatory
Default Value
Resource OBS Type
resourceOBSTypeKey_1
Single-select
Query
Resource OBS Type
resourceOBSTypeKey_1
No
Resource OBS Unit
resourceOBSUnitKey_1
Single-select
Query
Resource OBS Unit
resourceOBSUnitKey_1
No
Resource Manager
resourceManagerKey_1
Multiple-select
Query
Resource Manager
resourceManagerKey_1
No
Booking Manager
bookingManagerKey_1
Multiple-select
Query
Booking Manager
bookingManagerKey_1
No
Resource Role
roleKey_1
Multiple-select
Query
Resource Role
roleKey_1
No
Resource
resourceKey_1
Multiple-select
Query
Resource
resourceKey_1
No
Employment Type
employmentTypeKey_1
Multiple-select
Query
Employment Type
employmentTypeKey_1
No
Skill
skillKey
Multiple-select
Query
Skill
skillKey
No
Interest (Greater Than or Equal To)
resourceInterest
Single-select
List of Values
Interest (Greater Than or Equal To)
resourceInterest
Yes
1 - Low
Proficiency (Greater Than or Equal To)
resourceProficiency
Single-select
List of Values
Proficiency (Greater Than or Equal To)
resourceProficiency
Yes
1 - Beginner
Sort By
sortResourceProficiency
Single-select
List of Values
Sort By
sortResourceProficiency
Yes
Resource
Include Inactive Resources?
includeInactiveResources
Boolean
Include Inactive Resources?
includeInactiveResources
No
Unchecked
Show Graph?
showGraph
Boolean
Show Graph?
showGraph
No
Checked
Database Schema
ppmDBSchema
Hidden
Not applicable
Yes
Passed through
Clarity PPM
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through
Clarity PPM
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Parameter Lookup Values
Employment Type:
Contractor, Employee
Interest (Greater Than or Equal To):
1-Low, 2-Low, 3-Low, 4-Medium, 5-Medium, 6-Medium, 7-Medium, 8-High, 9-High, 10-High
Proficiency (Greater Than or Equal To):
1-Beginner, 2-Beginner, 3-Beginner, 4-Advanced, 5-Advanced, 6-Advanced, 7-Advanced, 8-Expert, 9-Expert, 10-Expert
Sort By:
Resource, Proficiency
Parameter Explanations
The following list describes the parameters:
  • The Resource OBS Type is a cascading parameter that determines which units are listed in the Resource OBS Unit parameter. This parameter does not directly control which resources appear in the report.
  • The Resource OBS Unit parameter displays the values that are based on the Resource OBS Type selected. Select an OBS unit in this parameter. The report displays the resources that are attached to the OBS unit and any descendants.
  • The Interest (Greater Than or Equal To) parameter uses skill interest level to determine which resources appear in the report. Interest indicates how important this skill is to the resource. The three interest levels are Low, Medium, and High, which can be further refined by identifying sublevels within the level. For example, a resource with an interest level of 3-Low has more interest than one with a level of 1-Low. The Interest (Greater Than or Equal To) parameter works as follows:
1-Low
–Resources with an interest level greater than or equal to 1-Low display in the report.
2-Low
–Resources with an interest level in performing a skill greater than or equal to 2-Low display in the report.
3-Low
–Resources with an interest level in performing a skill greater than or equal to 3-Low display in the report.
4-Medium
–Resources with an interest level in performing a skill greater than or equal to 4-Medium display in the report.
5-Medium
–Resources with an interest level in performing a skill greater than or equal to 5-Medium display in the report.
6-Medium
–Resources with an interest level in performing a skill greater than or equal to 6-Medium display in the report.
7-Medium
–Resources with an interest level in performing a skill greater than or equal to 7-Medium display in the report.
8-High
–Resources with an interest level in performing a skill greater than or equal to 8-High display in the report.
9-High
–Resources with an interest level in performing a skill greater than or equal to 9-High display in the report.
10-High
–Resources with an interest level in performing a skill greater than or equal to 10-High display in the report.
  • The Proficiency (Greater Than or Equal To) parameter uses skill proficiency level to determine which resources appear in the report. Proficiency indicates how well a resource performs the skill. The three proficiency levels are Beginner, Advanced, and Expert, which can be further refined by identifying sublevels within the level. For example, a resource with a proficiency level of 3-Beginner has more expertise than one with a level of 1–Beginner. The Proficiency (Greater Than or Equal To) parameter works as follows:
1-Beginner
–Resources with a proficiency level in performing a skill greater than or equal to 1-Beginner display in the report.
2-Beginner
–Resources with a proficiency level in performing a skill greater than or equal to 2-Beginner display in the report.
3-Beginner
–Resources with a proficiency level in performing a skill greater than or equal to 3-Beginner display in the report.
4-Advanced
–Resources with a proficiency level in performing a skill greater than or equal to 4-Advanced display in the report.
5-Advanced
–Resources with a proficiency level in performing a skill greater than or equal to 5-Advanced display in the report.
6-Advanced
–Resources with a proficiency level in performing a skill greater than or equal to 6-Advanced display in the report.
7-Advanced
–Resources with a proficiency level in performing a skill greater than or equal to 7-Advanced display in the report.
8-Expert
–Resources with a proficiency level in performing a skill greater than or equal to 8-Expert display in the report.
9-Expert
–Resources with a proficiency level in performing a skill greater than or equal to 9-Expert display in the report.
10-Expert
–Resources with a proficiency level in performing a skill greater than or equal to 10-Expert display in the report.
  • The report has a Sort By parameter that allows you to control how the report is sorted. The following sort options are available:
Resource
This option sorts the report by the resource name, in ascending order, within each skill grouping.
Proficiency
This option sorts the report by the proficiency, in descending order, within each skill grouping.
  • The Show Graph parameter controls whether the column chart displays in the report. If the parameter is checked, the chart displays on the first page of the report.
Report Fields and Calculations
The report displays the resource name, primary role, resource manager, booking manager, employment type, skill proficiency, and skill interest. The report displays labor resources because skills are only supported on labor resources. Roles are excluded.
When the show graph parameter is selected, the report also includes a stacked column chart. The column chart displays the number of resources in the skills hierarchy. The columns are grouped by the top parent skills in the hierarchy. The chart also displays the split of the parent skills between employment types. This split provides visibility into the number of employees and contractors with each parent skill. The amounts in the chart are a summary of all the resources that meet the parameter criteria of the report. 
Report Security
Resource view rights determine report security.