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
