Oracle Fusion AI Data Platform Forum

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

Categories

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 Forum

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