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

Employee active in 2025

Received Response
11
Views
1
Comments
Stefano_Mazzocca
Stefano_Mazzocca Rank 6 - Analytics & AI Lead
in Oracle Fusion Data Intelligence

We want to retrieve all employees active in 2025.

We are using the Year object under Time folder but if we use it all data seems lost, are we doing anythig wrong?

image.png

we tried also with Headcount metric

Tagged:

Answers

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    I do not have the instance handy, but can you see if Hire Date and Termination Date are available in the Subject Area and following logic can give you active employees in 2025

    Hire Date <= '31-Dec-2025'
    AND (Termination Date IS NULL OR Termination Date >= '01-Jan-2025')