report run multiple times with multiple prompts values

Requirement : One cognos report need to run multiple times with multiple prompts values, schedule.
Solution:

1. Prepared excel sheet with all values with respect prompt
2. Load into Event studio agent package (package should hold query iteam which keeps all report prompt values)
3. Create one agent in event studio using event studio packge
4. Configured report in newly created agent
5. Schedule that agnet to run date/time (hourly,daily,weekly)
6. Example :
1.  Agnet will run on every 1 hour.
2.  1st time agent and report will run on 8PM, then agnet will pass prompt values "India" to report
3.  2nd time agent and report will run on 9PM, then agnet will pass prompt values "China" to report
4.  3nd time agent and report will run on 10PM, then agnet will pass prompt values "Japan" to report

Excel sheet data

----------------

Country                  Time

=======               =====

India                       8 PM

China                      9 PM

Japan                      10 PM

UK                         11 PM

US                          12 PM

 

 

Thanks