How To Create a Cross-Subject Area Analysis for HCM

Here's how to create a real-time analysis that includes more than one subject area, which is referred to as a cross-subject area analysis. In this example, you create an analysis of headcount by department with the annualized salary in the local currency.

These are the key decisions for this scenario.

Decisions to Consider	In This Example
Which subject areas are needed?	For headcount by department, select Workforce Management - Worker Assignment Real Time. For salary, select Compensation - Salary Details Real Time.
Does the analysis require an SQL statement?	Yes, to join the two subject areas.

Create a Cross-Subject Area Analysis

1. In the Reports and Analytics work area, click Browse Catalog.

2. Click New and select Analysis.

3. In the Select Subject Area window, select the Workforce Management - Worker Assignment Real Time subject area.

4. In the Subject Area region of the Criteria tab, expand the Department folder.

5. Click Name and drag it to the Selected Columns area.

6. Expand the Worker Assignment folder.

7. Click Headcount and drag it to the Selected Columns area to the right of the Department Name column.

8. In the upper-right corner of the Subject Areas region, click Add/Remove Subject Areas.

9. In the Add/Remove Subject Areas window, select Compensation - Salary Details Real Time.

10. Click OK.

11. In the Subject Areas region of the Criteria tab, expand the Compensation - Salary Details Real Time folder.

12. Expand the Salary folder.

13. Click Annualized Salary and drag it to the Selected Columns area to the right of the headcount column.

14. Click the Results tab to see the results of the analysis.

15. Click the Criteria tab again to return to the analysis definition.

16. In the Subject Areas region on the Criteria tab, expand the Salary Details folder in the Compensation - Salary Details Real Time folder.

17. Click Apps Local Currency Code and drag it to the Selected Columns area to the right of the Annualized Salary column.

18. Click the Results tab to view the report again. The headcount column is now blank.

19. To correct the blank headcount, click the Advanced tab.

20. On the Advanced tab, scroll down to the Advanced SQL Clauses region.

21. Select the Dimension check box.

    When you select this check box, the logical SQL is appended with the following request variable value, enabling you to join the two subject areas: SET VARIABLE ENABLE_DIMENSIONALITY = 1;

22. Click Apply SQL.

23. In the Message from Web page window, click OK.

24. Click the Results tab again to see that the headcount column now has numbers.

25. Click Save Analysis.

26. Save to My Folders, and enter Headcount by Department in the Name field, and enter a description for your analysis.