Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: tushar gaurav on 24 Jan 2018 04:12:25 AM

Title: Need to send alert/mail if the report is executed with no data.
Post by: tushar gaurav on 24 Jan 2018 04:12:25 AM
Hi,

I have scheduled report which sometimes gets executed with no data.
Now I need to have alerts or mail when executed report results in no data.
Can anyone please help in achieving this scenario.

Thanks and Regards
Tushar Gaurav
Title: Re: Need to send alert/mail if the report is executed with no data.
Post by: Nikhil Shenoy on 24 Jan 2018 10:11:34 PM
Hey Tushar,

You can achieve it through Alert Studio.

You get an option there to send an email when the condition is fulfilled, not fulfilled, in case of error, etc. Refer screenshot

Hope this helps!
Title: Re: Need to send alert/mail if the report is executed with no data.
Post by: ggray on 19 Jul 2018 12:56:29 PM
How do I get this Alert Studio? I am using 11.0.7. I tried setting this up in Event Studio, but it appears that is nothing more than a scheduled report. I only want it to trigger an Event(Email) when a certain threshold is met.
Title: Re: Need to send alert/mail if the report is executed with no data.
Post by: MFGF on 20 Jul 2018 03:57:32 AM
Quote from: ggray on 19 Jul 2018 12:56:29 PM
How do I get this Alert Studio? I am using 11.0.7. I tried setting this up in Event Studio, but it appears that is nothing more than a scheduled report. I only want it to trigger an Event(Email) when a certain threshold is met.

There is no such thing as Alert Studio. I think the responder means Event Studio...
Title: Re: Need to send alert/mail if the report is executed with no data.
Post by: ckapark on 03 Nov 2020 05:12:20 PM
Hi, I have the same question.  Unable to open the attachment.  We are on version 10.2.1

Any help greatly appreciated!

Kathleen

Title: Re: Need to send alert/mail if the report is executed with no data.
Post by: BigChris on 04 Nov 2020 12:20:27 AM
You would need to create an event in Event Studio for this. Essentially, you'd count the records and if the result is zero (or is missing) then you'd send out the email.
Text only | Text with Images