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

What's wrong with this metric?

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

I have this metric:

image.png

SUM(
CASE
WHEN "HCM - Workforce Core"."HR Action"."Action Code" in ('HIRE','ADD_CWK','REN_CWK','ADD_CWK_WORK_RELATION') AND "HCM - Workforce Core"."Assignment Information"."Primary Flag Code" = 'Y' AND "HCM - Workforce Core"."Assignment Information"."Assignment Status Type Code" = 'ACTIVE'
THEN 1
ELSE 0
END
)

What could be the reason why from time to time it counts 2 on the same person?

image.png

For instance person 2333 has only 1 assignment so I expect to count 1. He was also terminated once but the "Assignment Status Type Code" = 'ACTIVE' filter should exclude the record. What else could be the cause?

Tagged:

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hello @Stefano_Mazzocca

    I don't think we have enough details to provide a specific answer but the starting point would be FA>HCM and check the history of PersonID 2333. Does the person have more than one assignment, are they all inactive, when and how was the change made compared to the last Pipeline?

    Maybe if you added the logical SQL (with no PI) we could add more.

    Regards,

    John