nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

how to get the termination date of managers

User_D9N49

step 1 : get list of managers

step 2 : add "termination date", but it's not for managers, but for workers.

question: how to get the termination date of managers

Find more posts tagged with

OTBI

Accepted answers

gclampitt

You could use a subquery within otbi ie "results based upon another analysis

ie the subquery returns a list of managers, then the main query gets the term date details for these people.

select worker number, term date where worker number in (select manager number…..)

All comments

John Hung-Oracle

Hi, To better serve you, please post your question in the Reporting and Analytics for HCM forum since its specific to HCM subject areas/use cases. Thank you.

gclampitt

You could use a subquery within otbi ie "results based upon another analysis

ie the subquery returns a list of managers, then the main query gets the term date details for these people.

select worker number, term date where worker number in (select manager number…..)

User_D9N49

thank you all for answering~