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

Compare output and Send email

Started by bwalikar, 18 Oct 2016 11:10:05 AM

Previous topic - Next topic

bwalikar

Hi All,
I have a requirement to run a crosstab report daily and compare it with previous day's output and send an email in following cases :
a ) if there is any difference in numbers in any of the intersection.
b) if any new row is added to the crosstab.

Report output Format : HTML.

Your help would be highly appreciated.

AnalyticsWithJay

This could be done via SDK or Event Studio.

For Event Studio, you could create stored procedures that return row count and summary totals. I don't know your full requirements, but presumably if the intersection values are different then the rollup totals should generally be different. If both conditions are met, send an e-mail.