In the Advanced Reporting tool, you want to create a query that includes the employee's...

Scenario Analysis

In the Advanced Reporting tool, the Job Relationships table is used to link employees to their various managers (e.g., matrix manager, HR manager, second manager).

By default, this setup may result in multiple rows per employee, as the relationships are not filtered for the specific manager type.

Solution

Configuring a table restriction allows filtering the Job Relationships table to include only rows corresponding to the desired relationship type (e.g., matrix manager).

This ensures that only one row per employee is returned in the query.

Why Other Options are Incorrect

A (Inner Join): Does not address the multiple rows issue and may exclude employees without a matrix manager.

C (Right Join): Similar to A, this does not resolve the issue and may include unrelated rows.

D (Left Join): Includes all rows but does not filter for the matrix manager.

References

SAP SuccessFactors Advanced Reporting Guide