Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How can I schedule a BI Publisher report with dynamic date parameters for the previous 3 months?

Summary:

We have a report used by many business areas. One particular business area would like to schedule this report to pick up the previous 3 months of data. How can I create this schedule to pick up this data dynamically?


Content (required):

The only options I see for dynamic date parameters are:

  • {$SYSDATE()$} - current date, the system date of the server on which BI Publisher is running.
  • {$FIRST_DAY_OF_MONTH()$} - first day of the current month
  • {$LAST_DAY_OF_MONTH()$} - last day of the current month
  • {$FIRST_DAY_OF_YEAR)$} - first day of the current year

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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