Oracle Fusion HCM Analytics

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

Categories

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

Absence information in FAW is as of Absence date but not as of today

21
Views
4
Comments
JP_UKHSA
JP_UKHSA Rank 1 - Community Starter
edited April 2024 in Oracle Fusion HCM Analytics

Hi 


Absence information in Fusion Analytics Warehouse is as of Absence date but not as of today. We observed in HCM Absence subject area (HCM-Workforce Absence Management) that all the information like location, department, organization,manager etc.. is as of the absence date and not as of current date. So if absence was taken on 5th Jan then all the attribute information is as of 5th Jan rather than 11 th march.. 


There is a requirement to see this information as of today so would like to know how we can achieve this with FAW current structures. Is there way to populate to new table based on current date by copying existing etl information. 


Much appreciate your help in this regard.


Thanks & Regards,

Jaydeep

Comments

  • Nupur Joshi-Oracle
    Nupur Joshi-Oracle Mod

    Hi @JP_UKHSA ,

    FDI Absence Management subject area is designed to give assignment attributes as of the date absence was availed - this is by design.

    If the ask is to plot assignment attributes as of today then - you can create your custom subject area using different features available in FDI like augmentation/semantic model extensions/data flow and bring absence data along with as of today assignment attribute.

    Regards,

    Nupur

  • JP_UKHSA
    JP_UKHSA Rank 1 - Community Starter

    Thanks Nupur. We are trying the same now by building new subject area.

  • User_Y8TLB
    User_Y8TLB Rank 3 - Community Apprentice

    Hi @JP_UKHSA, were you able to achieve this as we have similar requirement, any help here would be highly appreciated

  • User_Y8TLB
    User_Y8TLB Rank 3 - Community Apprentice

    Hi @JP_UKHSA ,

    Were you able to achieve this as we have similar requirement, any help here would be highly appreciated