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
Tagged:
0