COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: sheisella2019 on 24 Feb 2019 04:04:40 PM

Title: How to schedule cognos report dynamically to different emails
Post by: sheisella2019 on 24 Feb 2019 04:04:40 PM
0


I'm using congos analytics to schedule report to different emails dynamically according to different report types.

I'm exploring the bursting report features below but i found it only allows to links two queries ( data to be sent, and recipient list) together, however in my case the data to be sent is a whole report that is made of different queries. How can I make it happen?

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_set_burst_options.html#cr_rptstd_modrep_set_burst_options
Title: Re: How to schedule cognos report dynamically to different emails
Post by: Nikhil Shenoy on 28 Feb 2019 03:31:43 AM
You can write a job for your report and in that job you can create multiple schedules based on various parameters and select your recipient list accordingly.
Title: Re: How to schedule cognos report dynamically to different emails
Post by: dougp on 28 Feb 2019 03:45:08 PM
This appears to be the same question I saw on Stack Exchange.
https://stackoverflow.com/questions/54856414/how-to-schedule-cognos-report-dynamically-to-different-emails
Title: Re: How to schedule cognos report dynamically to different emails
Post by: ccb00mer on 19 Jun 2019 10:42:07 AM
While the Burst Feature only supports two queries, the actual report can have as many queries as you want to include.  You just have to set up report with a Master-Detail Relationship.  You can set up the burst and your page set with your Master query, then add as many detail pages and/or sub-queries as you want to include.