COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: b737 on 05 Aug 2013 12:24:31 PM

Title: Automatiion of report by rule
Post by: b737 on 05 Aug 2013 12:24:31 PM
Hi,
is there any chance to create some query or something else, which will run and create reports in Report Studio and export to excel according to value of some attribute. I am asking this because I have 30 department stores (Store1, Store2, Store3.....Store30), and now I can only run whole report at once for all 30 stores, and than in excel copy-paste for each one. Second option is to create prompt filter but also and in that case I need manually to chose Store1 (run report-export to Excel), than to chose Store 2 (run report-export to Excel).... and in that way 30x which I need to do every week and it takes lot of time and not to mention that is not so interesting  8)

Just to mention that I have relational model

Thanks
Title: Re: Automatiion of report by rule
Post by: Lynn on 05 Aug 2013 01:32:36 PM
Sounds like bursting might be what you need.

http://pic.dhe.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc%2Ft_cr_rptstd_modrep_bursting_reports.html
Title: Re: Automatiion of report by rule
Post by: b737 on 06 Aug 2013 04:17:05 AM
This would be helpful but I have relational model. Also in this moment only I can run reports for all Stores, they at the moment do not have possibility to use Cognos, s I need help.
Title: Re: Automatiion of report by rule
Post by: Lynn on 06 Aug 2013 06:53:51 AM
I think you should look into bursting a little more carefully. It absolutely works for a relational source and you have two options to distribute content to non-Cognos users. You can email content to users and/or you can save the output to a network drive.

The report studio user guide might be a better place to start.

The other option is to add a store prompt as you mentioned and then set up a job in Cognos connection that calls the same report 30 times passing a different prompt value each time. This is not an ideal solution really because you'll need to keep modifying the job steps whenever you have stores added or dropped. Bursting will automatically handle the distribution in a totally data-driven manner.
Title: Re: Automatiion of report by rule
Post by: b737 on 13 Aug 2013 04:34:00 AM
Thank for your help, I have read it better so I would try it.