Submitted by Sachin J. Kulkarni, BlueCross BlueShield of Tennessee
Turbo Integrator processes, when executed interactively, lets users know whether the process completed successfully or not. For those TI processes that are executed through chore, the outcome of the process execution (success and/or failure) is determined by looking at the target cube or sifting through the log files. Processes that are critical to end users often warrant an e-mail to support team, should the process in question were to fail.
This article stems from such a need, where in the support team for a business critical application in TM1 required e-mail notifications, on when chore began, succeeded or failed. To accomplish this we need three important pieces – a VB Script, a TM1 cube and a TI Process.
We created a cube (E-mail) that acts as data repository for various monitored processes. Then we created a TI process (Email Using Cube) that accepts a parameter and sends e-mail based with the help of a VB script (SendMailWithParameters.vbs). You can modify these three objects to suit supplementary requirements such as – include CC, BCC information, sending as HTML/outlook rich format instead of plain text, increasing the priority of the e-mail, etc.
This technique has been tested on a 9.5.2 as well as 10.1 TM1 server installed on win 2008 R2 server with Outlook 2007.
The VB Script uses the CDO object to send e-mail. If you are moving to Outlook 2010, although we have not tested it, we are given to understand that this technique may not work. See this Microsoft article for a workaround – http://support.microsoft.com/kb/2028411/en-us.