Join in OTBI is not removing data where joining two subject areas.

Summary:

When joining two subject area's the data is not removing information in one of the subject areas.

Content (please ensure you mask any confidential information):

Join between workforce management - assignment details real time and Payroll - Payroll costing setup details real time. The report is to bring in the information in the costing for persons screen for workers. However, this is a report which needs to be for line managers to see their employees only. The data is finding the line managers employee fine, and that is filtering correctly, but the costing information is not joining. It is showing every costing in the system. How do I get this report to filter that subject area also? The person number in the payroll subject area,