How AsOfDate working in FAW?

Meme 0101

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..

Subha_Tripathy-Oracle

Hi @user966776 ,

Please try the below link:

"Create a Date Part Parameter in Oracle Analytics"

https://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-create-date-part/index.html#before_you_begin

Thanks

Subha