Oracle Fusion Data Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Fusion Data Intelligence Idea Lab

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

More Information Requested
1
Views
0
Comments
JP_UKHSA
JP_UKHSA Rank 1 - Community Starter
edited Jul 15, 2024 5:53PM in Oracle Fusion Data Intelligence Idea Lab

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

Tagged:
1
Up
1 votes

More Information Requested · Last Updated

OTBI renders data based on current assignment. However , then analytical use cases like how was Absence Approval Rate of X BU in 2020 vs Absence Approval Rate in 2022 cannot be accomplished with everything rendering based on current assignment. Please share the use case for rendering data based on current assignment. Also , how would you want the security to work when you have data getting rendered based on current assignment ?