COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Event Studio => Topic started by: Sans on 08 Oct 2019 07:43:40 AM

Title: Email a report ONLY IF it has rows
Post by: Sans on 08 Oct 2019 07:43:40 AM
Hi to all

I've this simple problem:
- we have a report that actually runs on a scheduled basis and sends an email to 6 people eachtime it runs.
- Since the report has filters it could happen that an output with "No Data" is produced
- we'd like to send the email only if the report, when runs, is producing valid rows

How to manage this condition in Event Studio ??

Thanks
Title: Re: Email a report ONLY IF it has rows
Post by: Francis aka khayman on 08 Oct 2019 08:47:41 AM
count rows? does the report have a measure? you can check the total(xx) <> 0
Title: Re: Email a report ONLY IF it has rows
Post by: adam_mc on 08 Oct 2019 11:51:27 AM
Use the burst feature - In that way you won't need Event Studio at all.

If the report has rows, create a burst list of the email recipients.
If the report has no rows, create an empty burst list.

Use the burst list to control the recipients, it will in effect try and send the report to no one if there is no output.
If I remember correctly I believe you will get a warning in the report run history that it tried to send it with an empty burst list.

Hope this helps,
Adam.
Title: Re: Email a report ONLY IF it has rows
Post by: ckapark on 03 Nov 2020 05:14:45 PM
How do you configure it to the count the rows?

I am very new to this product - so detailed instructions would be greatly appreciated!!

Kathleen