Struggling to join two subject areas
Content
Morning all,
I built a Work Permit report a while ago that I now want to add Job / Department / Manager details to, but I'm struggling to get a join to work to the Worker Assignment Real Time folder.
I have followed Julian's video exactly, adding in the Manager dimension from the Worker Assignment Real Time subject area (as it exists in both subject areas), ticked the Dimensionality box and applied the SQL, but I still get the standard incompatibility error.
I've attached the catalog from my existing report, as well as the amended report that doesn't work. Can anyone see where I am going wrong?