Oracle Fusion AI Data Platform

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion AI Data Platform

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Employee active in 2025

Accepted answer
31
Views
1
Comments
Stefano_Mazzocca
Stefano_Mazzocca Rank 6 - Analytics & AI Lead
in Oracle Fusion AI Data Platform

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:

Best Answer

  • RVohra
    RVohra Mod
    Answer ✓

    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')