OTBI Report as on effective date — 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

OTBI Report as on effective date

edited Jun 29, 2023 12:25PM in Reporting and Analytics for HCM 9 comments

Summary:

Want to generate OTBI report as on effective date other than sysdate

Content (required):

We have a requirement to fetch data as on 1 day before the current date, we used following expression in OTBI report in Prefix under Advanced tab. It errors.

SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}{TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE)}';


When the same is done using the hardcoded date as below, it works.

SET VARIABLE PARAM_EFFECTIVE_DATE='2023-06-22';

Please advise if there is any syntax issue in the above expression

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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