You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Set PARAM_EFFECTIVE_DATE in OAC/FAW

Received Response
8
Views
1
Comments
edited Jul 15, 2021 10:05AM in Oracle Fusion Analytics 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!