Email Alerts with PAW

Post Reply
chewza
Regular Participant
Posts: 150
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Email Alerts with PAW

Post by chewza »

Hi there

Can anyone recommend a good way to set up email alerts if a process fails? Is there any native functionality built into built into the latest versions of Paw? OR are we still stuck the gold old batch file approach? :)

Many thanks
Chris
burnstripe
Regular Participant
Posts: 198
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: Email Alerts with PAW

Post by burnstripe »

I believe the only way to return the state of the process is via a master process and getting the state code.

A way around this may be to create a generic process to execute desired process and pass the relevant parameters. And map the buttons to the generic process instead.

The master parameter may have some of the following parameters
- process (process name wish to call)
- param1 (first parameter of process)
- param2 (second parameter of process)
-.... And so on

Then it could return the state of the process and on failure trigger an email alert
ardi
Community Contributor
Posts: 154
Joined: Tue Apr 02, 2013 1:41 pm
OLAP Product: tm1, cognos bi
Version: from TM1 9.4 to PA 2.0.9.6
Excel Version: 2010
Location: Toronto, ON

Re: Email Alerts with PAW

Post by ardi »

I use a different approach. I have a 3-dimensional cube, with one of dimensions being }Processes where for each process I have a few flags such as : email on successful completion, email on complition with minor errors and email on failure with major error

Then in Epilog of each process I have a few codes checking the process execution status and based on Status and the values defined for the Flags above, i send the email to the appropriate group of people
Ardian Alikaj
Wim Gielis
MVP
Posts: 3126
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Email Alerts with PAW

Post by Wim Gielis »

Maybe not in real time but near-real time.
You could have a chore that looks at the ProcessError files (from a certain day/time period like last 5 minutes), merge the files and send out the email.
PowerShell is something I used to retrieve the contents of said files and send a 'summary' email with errors/issues.
Or use a TM1 REST API solution to retrieve this information.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply