Reporting on Termination and Performance Review Data in the same analysis

Summary

I am trying to pull a report that shows employees performance review rating before their termination as well as their termination reason.

Content

I am attempting to join the Workforce Performance-Performance Rating Real Time and Workforce Management-Worker Assignment Real Time subject areas. I was able to program the report to pull the performance review closest to their termination, but when I try to bring in Action Reason or Action Code from the Worker Assignment Real Time subject area the report errors. I am using Average Calculated Overall Rating from the Performance Rating Real Time subject area.

I tried to link the subject areas by bring in a measure from both and checking off DIMENSIONALITY in the Advanced settings, but the report is still erroring. Both subject areas have values from Worker in the report.