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

Run Event only if Report > 0 rows

Started by bshim, 18 May 2020 01:58:51 PM

Previous topic - Next topic

bshim

I want to run and email a report only if it has rows in it. Is there a way to do this within the Event Studio in Cognos Analytics 11? I see that you can write expressions from a package, but if I am using this to replicate a complex report, it can get very messy.

I have done a little browsing it brings me to the Cognos 10 BI section of the forum. I'm not sure how closely related Cognos 10 BI and Cognos Analytics 11 are related. Below is the best solution I've found for BI, do you think this is the best solution for Analytics as well?

https://www.cognoise.com/index.php/topic,20964.msg63385.html#msg63385
(Create package based off SQL from report/query)

dougp

How about bursting?  Use only one grouping.  No data, nothing matches the group, so no email.

bshim

Quote from: dougp on 20 May 2020 12:16:54 PM
How about bursting?  Use only one grouping.  No data, nothing matches the group, so no email.

Thanks for the reply! From a glance at the documentation, this looks like the answer. Looking forward to implementing it over the next few days.