Oracle Fusion Data Intelligence

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

How AsOfDate working in FAW?

Received Response
31
Views
1
Comments
Meme 0101
Meme 0101 Rank 3 - Community Apprentice

In OTBI, we can run a report with an effective date by putting for example SET VARIABLE PARAM_EFFECTIVE_DATE='2021-07-31'; in the PREFIX. This would show us how the data looked on a specific day in the past/future.

How would we do this in OAC/FAW? I have created a report based on the HCM Core Subject Area but I wish to run it as of a certain date - ultimately I would have this as a prompt so the user can set the effective date themselves e,g, Run report as of..

Answers