Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Set PARAM_EFFECTIVE_DATE in OAC/FAW — Cloud Customer Connect
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..

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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