Hi,
I have developed a report with location prompt. At the moment users can only run this report by selecting a single location, but in future we would like to automate this report and run this report for all the locations one after the other, and save the output to an external file system. Aim is to have output for all location saved in an external file system.
Can someone please advise what I need to do in cognos report studio so this report can be run for each location in the prompt one after the other. I am using Cognos 8.3.
Thanks
Karan.
Hi,
One thing which you can do is add a static choice value as 'ALL' in the prompt value filter for location.
For this 'ALL' choice you have to write following code in the query filter as :
[Location field]= if(?location?='ALL')
THEN
[Location field]
else
(?location?)
HTH!
Hi Aarti,
Thanks, but this will result in selecting all the location at the same time. I am interested in selecting one location at a time and runnings the report for that location, save the output and then run it again for the next location.
Can we do this in cognos 8.3 or do we need to write an external procedure. I remember in 7.3 we could write macro for impromptu reports where we could run for loop and run report unless the report has run for all the values in a prompt.
Karan.
Hi Singh,
Using Event Studio you can automate your report to produce an output for each location. All you have to do is create report task in event studio for each location.
Thanks,
I am not familiar with Event Studio. But we do have event studio here, so I will try.
Can you please point me to a documentation which explains how to create tasks in event studio for report studio reports.
Karan.
U can get Event Studio user guide from Cognos Knowledge base.
I used event studio and created a task to run a report. I tested this on 10 locations and it worked.
I have 160 locations and now problem is that I had to add 160 different prompts to this tasks.
Can you please suggest if I can do something else in event studio other than creating 160 prompts.
Thanks.
According to my knowledge you need to create 160 report tasks in event studio if you want to schedule a report for 160 promptvalues.
Why not use report Bursting by Location?
Thanks I thought about bursting. I never used it before so I am not sure about few things,
1. I need to save the reports on our network drive, can we burst reports to external file system.
2. When we burst reports can we save them with different names?
For example "Store Report - Location Name" and this "location name" will be different for each report.
Karan.