Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to get the termination date of managers

Accepted answer
31
Views
3
Comments
User_D9N49
User_D9N49 Rank 1 - Community Starter
edited Oct 29, 2024 7:50AM in Oracle Transactional Business Intelligence Forum

step 1 : get list of managers

image.png

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

image.png

question: how to get the termination date of managers

Tagged:

Best Answer

  • gclampitt
    gclampitt Rank 6 - Analytics & AI Lead
    Answer ✓

    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…..)

Answers