COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: dresske_tuik on 06 May 2013 05:43:20 AM

Title: Run report 500 times with diff param value
Post by: dresske_tuik on 06 May 2013 05:43:20 AM
I there.

I have created a report which runs with one input parameter.
That report must run approx. 500 times, each time with a different input.

How can that be automated?

Result should be 500 PDF files once a week saved a specific folder.


Thanks in advance for any ideas!
Mathias
Title: Re: Run report 500 times with diff param value
Post by: CognosPaul on 06 May 2013 06:03:53 AM
You might want to try bursting the report.
Title: Re: Run report 500 times with diff param value
Post by: TheBrenda on 15 Jul 2013 11:25:09 AM
I have been looking for the same thing. Finally decided to use Cognos BI 10 where you can setup a single job with multiple steps. The single job can have defaults (such as the schedule) and each of the 500 steps just have different parameter values. It is a one time setup of 500 steps, but all you are changing is the parm.