How to show 2 result sets in one otbi analysis - Cloud HCM (Learning)

Richard Davis

Hi all

Looking to get some insight from the wider community on HOW to combine 2 sets of filtered data into a consolidated analysis.

The ask from Customer is to have for learning allocations a specific set of workers that meet criteria, associated with layers within department hierarchy, as well as Assignment Status as well as classification of level of worker in organisation (Leader Profile) - ALL of this is achieved and works leveraging the "Workforce Management - Worker Assignment Real Time" SA - this performs as expected

Structure of query is as follows

Filter is as follows

BUT

There is a small population of workers that dont fall into the filter criteria or Department, Assignment Status, and Level of Worker- they are the exceptions that are called out by name

I have saved the original query where dept, assignment, level is working, saved as another query, removed the filters but then added in filter for Name of workers - this report works as expected and the names of the workers I was expecting to see are returned without issue

HOWEVER

When wanting to then have both queries in one analysis, I don't get the results of the 2 queries appearing

I have tried to associate the 2nd analysis against the 1st analysis

Looking for any guidance tips and tricks that others may have in this space

For our learning activity we have over 150 learning initiative allocations that will be leveraging this approach - each of them unique and with a similar approach of inclusion and exclusion based on participation of the learner in other learning initiative allocations

Any help is most appreciated

Richard