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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need to send alert/mail if the report is executed with no data.

Started by tushar gaurav, 24 Jan 2018 04:12:25 AM

Previous topic - Next topic

tushar gaurav

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

Nikhil Shenoy

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!

ggray

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.

MFGF

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...
Meep!

ckapark

Hi, I have the same question.  Unable to open the attachment.  We are on version 10.2.1

Any help greatly appreciated!

Kathleen


BigChris

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.