Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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