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)
How about bursting? Use only one grouping. No data, nothing matches the group, so no email.
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.