Author Topic: Run Event only if Report > 0 rows  (Read 482 times)

Offline bshim

  • Associate
  • **
  • Join Date: May 2020
  • Posts: 2
  • Forum Citizenship: +0/-0
Run Event only if Report > 0 rows
« on: 18 May 2020 01:58:51 pm »
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)

Offline dougp

  • Statesman
  • ******
  • Join Date: Jul 2014
  • Posts: 536
  • Forum Citizenship: +23/-1
Re: Run Event only if Report > 0 rows
« Reply #1 on: 20 May 2020 12:16:54 pm »
How about bursting?  Use only one grouping.  No data, nothing matches the group, so no email.

Offline bshim

  • Associate
  • **
  • Join Date: May 2020
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Run Event only if Report > 0 rows
« Reply #2 on: 21 May 2020 12:47:08 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.

 



       
Twittear