Hi,
I have a requirement where user enters data into the cubes through worksheets and clicks on a button which fires an email to his manager to view what did he just enter. Is there anyway we can accomplish this scenario.
Thanks
Daya
Email Feature in TM1
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Email Feature in TM1
Yes it's possible and not too difficult.
All you will need is:
- a 3rd party email application with command line interface
- access to your company's SMTP server gateway
- fire the email application with ExecuteCommand from TI
- appropriate parameters for the email TI and lookup cubes to compose the emails and send them to the right places
- an IT department who will let you do the above (often the most difficult part of the whole process.)
There are several suitable email applications out there, most of them are shareware/freeware.
All you will need is:
- a 3rd party email application with command line interface
- access to your company's SMTP server gateway
- fire the email application with ExecuteCommand from TI
- appropriate parameters for the email TI and lookup cubes to compose the emails and send them to the right places
- an IT department who will let you do the above (often the most difficult part of the whole process.)
There are several suitable email applications out there, most of them are shareware/freeware.
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: Email Feature in TM1
Nothing built in to TM1 - but google 'email VBA' and you'll find many, many articles explaining how to generate emails programmatically from Excel.
If you want to do it server side, create a VBScript routine and call it with TI using ExecuteCommand.
But for your requirement, client side seems to fit rather well.
If you want to do it server side, create a VBScript routine and call it with TI using ExecuteCommand.
But for your requirement, client side seems to fit rather well.
-
- Posts: 49
- Joined: Fri May 28, 2010 4:47 am
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2003
- Location: IL, USA
Re: Email Feature in TM1
Thank you for the comments. I will research on vba email feature and get it done.
-
- Posts: 82
- Joined: Thu Jun 03, 2010 3:50 am
- OLAP Product: Cognos TM1
- Version: 9.5.0 64-bit
- Excel Version: 2003 SP3
Re: Email Feature in TM1
Yeah, this is very strange to me you know. Especially when you look at TM1 Contributor.David Usherwood wrote:Nothing built in to TM1
When people see workflow their minds will automatically jump to automatic e-mail notifications.
But no, IBM's mind doesn't jump to this.
Windows Server 2003 Enterprise x64
Windows XP Pro 2002 SP3
Internet Explorer 7
Windows XP Pro 2002 SP3
Internet Explorer 7
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: Email Feature in TM1
Contributor is (to be kind) an initial implementation of some of the features of Cognos Enterprise Planning in TM1. Email notification didn't make the first cut, but is coming.