Fusion Analytics Warehouse

Products Banner

Set PARAM_EFFECTIVE_DATE in OAC/FAW

Received Response
251
Views
1
Comments

Summary

How to run report with effective date parameter

Content

Hi,

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

Thanks.

Answers