1. Creating and Administering Analytics and Reports for Project Management
  2. Create Analysis to View Resource Qualifications from HCM

Create Analysis to View Resource Qualifications from HCM

Create a resource qualification analysis in the Reports and Analytics work area to view real-time qualifications for project resources from the Oracle Human Capital Management (HCM) application.

When you create a resource qualification analysis, you select the Resource Name and Resource Qualification columns to display the qualifications associated to the resource. Resource Name and Resource Qualification dimensions are valid for the various facts associated with the Project Resource Management - Resource Management Real Time subject area. When you use Oracle Transactional Business Intelligence (OTBI) for a cross-dimension query, OTBI selects the fact column from the implicit fact column defined for a subject area to display the result. For the Project Resource Management - Resource Management Real Time subject area, the implicit fact column defined is # of Requests. Hence, OTBI displays the qualifications from the requests to which the resource is associated and not from the HCM application. For the analysis to display the qualifications as defined in their HCM Talent Profile, you must add the # of Qualifications column that is the relevant measure.

Creating a Resource Qualification Analysis

  1. Navigate to the Reports and Analytics work area.

  2. Click Browse Catalog.

  3. From the New menu, click Analysis.

  4. From Select Subject Area window, click Project Resource Management - Resource Management Real Time.

  5. In the Subject Area pane, expand:

    1. Resource folder and double-click Resource Name.

    2. Qualification folder and double-click Qualification Name.

    3. Project Resource Supply folder and double-click # of Qualifications.

  6. In the Selected Columns section, from the Resource Name column criteria, click Filter.

  7. In the New Filter window, select a resource from the Value list, and click OK.

  8. In the Selected Columns section, from the # of Qualifications column criteria, click Column Properties.

  9. On the Column Format tab, select the Hide check box and click OK to hide the # of Qualifications column in the analysis.

  10. Click Save Analysis.

  11. By default, the application selects the My Folders folder. Enter a name for your analysis, such as Resource Qualification Analysis, in the Name field.

  12. Click Catalog menu.

  13. Expand My Folders and open the Resource Qualification Analysis. The analysis contains the following details for your selected resources:

    • Resource Name

    • Qualification Name