COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: EyalR on 02 Jan 2020 02:20:11 AM

Title: Sending a scheduled report only when there is data.
Post by: EyalR on 02 Jan 2020 02:20:11 AM
Hi all (New here ;D),

Is it possible sending a report (by mail) only when there is data?
Would like to do so but not in Event Studio.


Thanks,
Eyal
Title: Re: Sending a scheduled report only when there is data.
Post by: BigChris on 02 Jan 2020 07:00:24 AM
You'll either need to do this in Event Studio, or alternatively set up a trigger when there is data on the server and schedule the report accordingly.
Title: Re: Sending a scheduled report only when there is data.
Post by: oscarca on 03 Jan 2020 03:09:00 AM
Use the burst feature when scheduling the report.
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_bursting_reports.html (https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_bursting_reports.html)
Title: Re: Sending a scheduled report only when there is data.
Post by: CognosPaul on 03 Jan 2020 10:52:12 AM
I agree with oscara. Set up the burst so it has the email addresses you want to send to, but only when there's data. If the burst query is null, it won't send.
Title: Re: Sending a scheduled report only when there is data.
Post by: MFGF on 03 Jan 2020 11:57:38 AM
Quote from: CognosPaul on 03 Jan 2020 10:52:12 AM
I agree with oscara. Set up the burst so it has the email addresses you want to send to, but only when there's data. If the burst query is null, it won't send.

Just to add to this, also be mindful of your licensing situation if you decide to use the bursting feature. Using bursting means that the report content is classed as being personalised for each burst recipient, and this means each of them needs a Cognos license to receive the report content according to IBM's licensing definitions.

Cheers!

MF.