Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

0 votes


Accepted answer

Permanent link
RTC BIR reports do not have scheduling mechanism. However, if you upgrade to RTC 301 or later, you can use RRDI (which ships for free with CLM) which would use Cognos reports and will also provide scheduling mechanism.
Friedrich Kammerlander selected this answer as the correct answer

4 votes


3 other answers

Permanent link
There is no such scheduler out-of-box. For long-runnning reports we use CURL (every report has unique URL) to generate it in the night.

3 votes


Permanent link
Thanks a lot for your answers!

I already created a unique URL for the report with the correct parameters, so I guess I will just create a script or something to call it in the night.

0 votes


Permanent link

Hi Friedrich,

Make sure your BIRT report doesn't have the issue described in this article:

http://www.ibm.com/developerworks/rational/library/add-a-rational-team-concert-data-warehouse-extension-for-custom-attributes/

Good luck!

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,020
× 230

Question asked: Apr 16 '13, 4:26 a.m.

Question was seen: 5,873 times

Last updated: Apr 16 '13, 10:42 a.m.

Confirmation Cancel Confirm