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

Join multiple subject areas in Analytics

edited May 7, 2022 9:02PM in Reporting and Analytics for HCM 1 comment

Summary:

Join multiple subject areas to have an outer joint result.

Content (required):

My users want a dashboard to show the percentage of the employees who set up annual career goals. I am building an analytics that needs to provide a total of all employees and a total of employees who set up their goals.

The subject area 'Workforce Management-Worker Assignment Realtime' can provide the total of all employees(FTEs).

The subject area 'Workforce Goals - Goal Status Overview Real time' can provide only the employees who set up the goals but not the employees who haven't done so.

I added two subject areas in the analytics and expected to get a list of two groups of employees described above. It is like an outer joint if using SQL. But the result of joining two subject areas cut off the 2nd group employees.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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