Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Dynamic effective date on Analysis — 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

Dynamic effective date on Analysis

Accepted answer


I am trying to get active employees as of a future date in Analysis "Workforce Management - Worker Assignment Real Time"

Content (required):

I am able to use a static date with the format YYYY-MM-DD in prefix to set a future date, but I wanted a dynamic value so I set the prefix as "SET VARIABLE PARAM_EFFECTIVE_DATE = '@{P_DATE}{@{system.currentTime}[YYYY-MM-DD]}';" and it worked. But to have a future date in dynamically hasn't worked. So I set a presentaion variable with SQL reaults query as (select timestampadd(SQL_TSI_DAY,10,CURRENT_DATE) from "Workforce Management - Worker Assignment Event Real Time") and the prefix as "SET VARIABLE PARAM_EFFECTIVE_DATE='{@{AsOfDate}[YYYY-MM-DD]}';" and it din't work.

Howdy, Stranger!

Log In

To view full details, sign in.


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