Creating new calculated measure using columns from multiple subject areas

Content

Good afternoon all,

I've created an OTBI report that combines the following subject areas:

• Workforce Management - Worker Assignment Event Real Time
• Workforce Management - Documents of Records Real Time
• Workforce Management - Person Real Time

I've included the following measures in the report to make the joins work:

• "Workforce Management - Person Real Time"."Person"."Person Count"
• "Assignment Event"."Assignment Event Count"
• "Workforce Management - Documents of Record Real Time"."Document of Record"

In brief, I'm using Person Real Time to filter Employees on a specific Visa and to show certain Employee Visa details.

I filter for specific Assignment Events and filter for specific recorded Document Types.