How to add Dynamic Parameters while Scheduling BI Reports

Most of the times we need our BI reports to run for changes till the current date/sysdate. But there are times when you want your report to run by picking a specific time range.
We can do this by passing Dynamic Parameters while Scheduling BI Reports.

For this you will have to do 2 steps.

1. Add Parameters to the Report

In Data Model, under Parameters click Create

• Name - Start_Date
• Date Type - Date
• Default Value - {$sysdate()-6$}
• Parameter Type - Date
• Display Name - Start Date

• Name - End_Date
• Date Type - Date
• Default Value - {$sysdate()$}
• Parameter Type - Date
• Display Name - End Date

This will help you to run the report online.

2. Add Value during Report Schedule

Go to the report, click on more then schedule
while scheduling the report, on general tab you will find 2 options in parameters
Start Date and End Date
In Start Date - {$sysdate()-6$}
In End Date  - {$sysdate()$}

Now when the scheduled report run it will run for 1 week.