TM1 Forum

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

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.

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.

Thank you for the comments. I will research on vba email feature and get it done.

David Usherwood wrote:Nothing built in to TM1

Yeah, this is very strange to me you know. Especially when you look at TM1 Contributor.
When people see workflow their minds will automatically jump to automatic e-mail notifications.
But no, IBM's mind doesn't jump to this.

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.