Creating a Multi-Domain Query

The cross-domain reporting feature allows you to add columns from different modules, and the query will auto-link the data. You can also use the Pivot Query Designer to aggregate fields across different modules after setting up the query. For example, a list report can display results from three different modules:

• SAP SuccessFactors HCM module: User Sys ID, First Name, Last Name, Hire Date, and Job Code
• Compensation module: Current Salary
• Performance module: Overall Performance Rating Description

The Detailed Reporting tool helps you identify which fields are available for cross-domain reporting. Once you add a field to the query, unavailable domain and field names under the Add tab turn gray, indicating that they cannot be joined to the working query.

When you have data coming into a query from more than one module, you will have access to Relationship Scope, an option on the Edit menu which tells you how the data is joined. The Compensation Planning User ID is joined with an inner join to Employee Profile User Sys ID. If you need to change the joined field, use either dropdown menu.