Autopopulated Prompt with Current_Date (SYSDATE) — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Autopopulated Prompt with Current_Date (SYSDATE)

edited Apr 25, 2019 10:47AM in Reporting and Analytics for HCM 7 comments

Content

Hello everyone,

We have a OTBI dashboard that contains analysis that is running As-Of date parameter. As-Of reporting was set up by adding SET VARIABLE PARAM_EFFECTIVE_DATE ='@{EffDate}'; in prefix.
We also created separate variable prompt EffDate to supply analysis with date in order to run it.

However, when user runs dashboard and before date is added we have usual sql error which is causing poor user expirience. In order to solve that, we want analaysis to run as of today (sysdate) as soon as user opens it and afterwards if needed, user can provide as-of date.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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