Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Creating Exit Projections by Month and Year in Fusion Data Intelligence

Accepted answer
23
Views
1
Comments
JT_DC_2023
JT_DC_2023 Rank 3 - Community Apprentice
in Oracle Fusion Data Intelligence

Hello everyone,

I’m currently working with Fusion Data Intelligence, and I’m trying to create a graph that shows exit projections (employee terminations/retirements) for each month and year.

My Data:

  • Current Columns: person number, termination date, retirement date

What I Want to Achieve:

I’d like to generate a projection of exits per month, where the exit could be either a termination or retirement, depending on which comes first. Specifically, I want to:

  1. Identify the first exit date for each employee (either from the termination date or retirement date).
  2. Group the exits by month and year to display the number of exits for each period.
  3. Visualize this data in a graph, with the X-axis showing the year/month and the Y-axis showing the number of exits.

Any advice or examples would be greatly appreciated!

Thanks in advance for your help!

Best regards

Tagged:

Best Answer

  • Rajesh L-Oracle
    Rajesh L-Oracle Mod
    Answer ✓

    Hi JT_DC_2023,

    Thank you for posting your question in Oracle Fusion Data Intelligence(FDI) HCM Product Community.

    We suggest using Workforce Core subject area for your requirement :
    In Workforce Core subject area, a daily snapshot of the active worker record is maintained. For example: If a worker was active between 1-Jan-2022 to 31-Dec-2022 then there will be 365 records of that worker. The snapshot includes the worker’s personal, employment and assignment information. When a worker is turned inactive due to termination then the termination record is captured as an event. From the next day of termination, the daily snapshot will not capture the inactive worker’s record.
    You can also use Active vs Inactive Headcount: Active Headcount provides the data of the workers that have the assignment status as Active. Inactive Headcount provides the data of the workers that have the assignment status as Inactive.

    In FDI, we also have Termination metrics based on the Termination Date.
    Termination Count(Termination Date)
    Voluntary Termination Count(Termination Date)
    Involuntary Termination Count(Termination Date)

    More Details can be found in FDI Docs:
    HCM—Workforce Core - This table describes all the Workforce Core metrics for Headcount and Termination:

    https://docs.oracle.com/en/cloud/saas/analytics/24r3/fahia/chapter-subject-areas.html#GUID-8E553DD0-8C57-438A-833E-1AE7FCB509C3
    If you would like to have OOB/Standard content & visualization for your business requirements please share your suggestions in following FDI IdeaLab :

    https://community.oracle.com/products/oracleanalytics/categories/idealab-fusion-analytics

    Hope the above information was helpful.
    regards,
    -Rajesh