If you are unable to create a new account, please email support@bspsoftware.com

 

Need help, Report studio Report - generating multiple outputs using same prompt.

Started by ksingh, 21 Apr 2009 10:01:34 PM

Previous topic - Next topic

ksingh

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.

ajaju

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!





ksingh

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. 

Gopinath

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.

ksingh

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.

Gopinath


ksingh

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.

Gopinath

According to my knowledge you need to create 160 report tasks in event studio if you want to schedule a report for 160 promptvalues.


ksingh

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.