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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

OTBI Analysis - Joining Work Relationship Real Time to the Checklist Real Time subject area

edited Nov 5, 2020 1:37AM in Reporting and Analytics for HCM 15 comments

Summary

Having an issue joining the two subject areas together

Content

In my OTBI analysis, i need to join the 'Workforce Management - Work Relationship Real Time' to the 'Workforce Management - Checklist Real Time' subject area. I have selected a measure from each subject area and checked the dimensionality. The analysis works until i pull in the Termination or Last Day Worked field. 

Is there anyway i can accomplish joining these two subject areas together. I am needing to leverage the last day worked field for my analysis. 

I have attached screen shots and catalog.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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