Struggling to join two subject areas — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Struggling to join two subject areas

edited Nov 15, 2019 11:11AM in Reporting and Analytics for HCM 4 comments

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!