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

 

How to schedule cognos report dynamically to different emails

Started by sheisella2019, 24 Feb 2019 04:04:40 PM

Previous topic - Next topic

sheisella2019

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

Nikhil Shenoy

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.


ccb00mer

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.