Email configuration with Workflow/TM1 Contributor

Post Reply
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

Email configuration with Workflow/TM1 Contributor

Post by Radhika »

Hi All,
Good Day.

Using TM1 Contributor/Workflow can we configure user emails where in during the planning process if any users update their budgeted values their one level up users should get an email notification regarding the change.
Please guide me how can I configure the user email ids against TM1 components.

Thanks,
Radhika
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Email configuration with Workflow/TM1 Contributor

Post by David Usherwood »

Someone can contradict me here, but I don't think TM1 Contributor supports emails - yet. It's one of the features of Cognos Contributor that didn't make it across.
Christopher Kernahan
Community Contributor
Posts: 147
Joined: Mon Nov 29, 2010 6:30 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Office 2010

Re: Email configuration with Workflow/TM1 Contributor

Post by Christopher Kernahan »

I haven't seen this done natively in TM1, but you can design a TI process to output a textfile to a folder location, and set up a Lotus Notes agent to run on that folder, converting the text file output (email, cc, bcc, subject, message) into an email.
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Email configuration with Workflow/TM1 Contributor

Post by qml »

Or, if you have an SMTP server in your company, use a command-line tool to send e-mails (same method as Christopher suggested - ExecuteCommand from a TI). There are a few free ones to download from the Internet.
Kamil Arendt
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Email configuration with Workflow/TM1 Contributor

Post by tomok »

qml wrote:Or, if you have an SMTP server in your company, use a command-line tool to send e-mails (same method as Christopher suggested - ExecuteCommand from a TI). There are a few free ones to download from the Internet.
The problem here, of course, is that this is still a "pull" mechanism, not a push. You still have to wrestle with how to create a TI process that can be established to run on a fixed interval (pretty easy) and be able to quickly determine when a specific budget value has been updated (not so easy to do) and then detemine the appropriate person to direct the email. The problems aren't insurmountable but certainly are not easy by any stretch.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply