When pulling fields from two subject areas, it often breaks and returns 0 results

Summary:

When trying to create an Analysis from two subject areas it doesn't work.

Example:

Workforce Management - Person Real Time I have the following fields: Address Line 1, Address Line 2, City, Region 2, Ethnicity, First name, Last Name, Assignment Category, Business Title, Enterprise Hire Date, Veteran Self-Identification Status, Self Disclosed Type, and Person Birth.

When these fields are added from a single subject area I get data.

However I need to add Org Level 2, Org level 3 and Org level 4, and Job Name to the report which doesn't exist in the first subject area.

To get this information I add a second subject area Workforce Management - Worker Assignment Event Real Time