OTBI - prefix for current date minus days — 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

OTBI - prefix for current date minus days

edited Feb 7, 2019 11:50AM in Reporting and Analytics for HCM 4 comments

Summary

How can I define prompt for an OTBI report which is the current date minus variable of days

Content

Hi,

I'm trying to create a prompt of number, so if the user will insert for example '20', the report will be effective for the current_date-20.

I'm trying to insert a prefix like this: SET VARIABLE PARAM_EFFECTIVE_DATE = '@{system.currentTime} -@{DaysMin}[YYYY-MM-DD]';

(DaysMin the a prompt var).

Unfortunately it does not work. 

Do you have any suggestion?

Version

R13 18c
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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