How can I schedule a report?
Hi everyone,
i created a report using the eclipse and BIRT that takes a long time to generate (~1h). It uses historical data from the data warehouse and is stable for 24h after the data collection jobs are finished. I enabled data caching, so the report takes a long time when it is run the first time of the day and is fast afterwards.
Now my question is if it possible to schedule the initial generation of the report each day right after the data collection jobs of for a fixed time (e.g. 3 am). Then the data should be cached and the first person who opens the report on a given day does not have to wait.
This would improve our process a lot, since the report is often only looked at once a day and it takes very long to load initially.
I know that it would better to speed up the report, but I already spend lots of time doing that and cut it down from > 12h and additional speed ups would be very complicated and time consuming.
Thanks a lot for your help!
Fred
p.s. we are using RTC 3.0
i created a report using the eclipse and BIRT that takes a long time to generate (~1h). It uses historical data from the data warehouse and is stable for 24h after the data collection jobs are finished. I enabled data caching, so the report takes a long time when it is run the first time of the day and is fast afterwards.
Now my question is if it possible to schedule the initial generation of the report each day right after the data collection jobs of for a fixed time (e.g. 3 am). Then the data should be cached and the first person who opens the report on a given day does not have to wait.
This would improve our process a lot, since the report is often only looked at once a day and it takes very long to load initially.
I know that it would better to speed up the report, but I already spend lots of time doing that and cut it down from > 12h and additional speed ups would be very complicated and time consuming.
Thanks a lot for your help!
Fred
p.s. we are using RTC 3.0