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

SQL Expression on column filter in OTBI report

edited May 12, 2021 10:10AM in Reporting and Analytics for HCM 4 comments

Content

Created a headcount report and looking for a SQL Expression for a column filter so I can generate the report based on current or system date employee start dates and future hires # weeks or # days ahead from the system/current date (ie. date the report is run)

I tried to use a timestampadd code but could only figure it out for retrieving past data (eg for terminations for the last month)

Version

Oracle Business Intelligence 11.1.1.9
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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