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

Sending report to email depending on trigger

Started by BerryK, 21 May 2014 06:43:20 AM

Previous topic - Next topic

BerryK

Hello everyone,

I was wondering the following:
I want to send a report by email when a trigger is activated. I know this is possible, though I want to have another option built into the process.
The scenario is roughly as follows:
During a periodic check on the database, a certain combination of date / time on a document or folder should activate a trigger. Depending on certain metadata plus said date/time, a report is sent to a certain email address.
Is it at all possible to have a trigger determine which email to send the report to?

Thanks in advance!  :D

Lynn

Sounds like a job for Event Studio. Have you looked into that?

BerryK

I did, but I couldn't find an answer to my question.

I have to add I'm kinda new to Cognos (awesome software btw!), but I'm willing to learn. I'm not looking for an exact pointer to 'where' I can find the option; I only want to know I'm not looking for something impossible.

From what I saw so far I understand I can send reports via email, I can set triggers as to why it has to be sent, I just wonder if it's possible to incorporate to whom it has to be sent depending on what fired the trigger...
Just hypothetically speaking; if I add an e-mail address as metadata to a document or folder and the event would send the report to that address, I would be a very happy guy :)

Lynn

You could create two agents. Both would have the date/time criteria in the event but the criteria that evaluates the metadata to determine the recipient would be different for the two agents and also of course the email task that gets fired would be different.

Another possibility might be to create a report that contains the logic to derive the appropriate email address based on that metadata. You'd run that report as a task from a single agent that is set to only evaluate the date/time criteria as the event trigger. You'd call the report and burst to email so the report would be doing the heavy lifting in terms of determining the recipient. Your ES agent would just call the report whenever the date/time criteria is met.

I have dabbled with Event Studio so if there is a better/easier way to do it then perhaps others will chime in with suggestions as well.

BerryK

Very expansive answer, Lynn, thank you so much! That gave me exactly what I was looking for.

...now I only have to make sure I can set it up like that, which is gonna be a first.

Here's to learning something new everyday. Cheers! :D

Lynn

If you decide to go the route of creating a report which bursts to one email or the other based on your metadata criteria then this technique for sending the report content as the body of an email might be useful. Altering the recipient based on the metadata would just be a matter of coming up with the right query calculation.

http://www-148.ibm.com/bin/newsletter/tool/landingPage.cgi?lpId=2781

Two agents may be simpler but then both are going to be hitting the database checking for their respective conditions rather than just one. Not sure it matters much but thought I'd mention it.

There are a lot of really helpful people here! The forum etiquette post provides some useful tips on how to get the best advice and answers so that is worth a peek if you haven't already looked at it. Good Luck!!