Email Notifications for a Tm1 Application

Post Reply
DYNA
Posts: 22
Joined: Mon Jul 29, 2019 10:09 am
OLAP Product: PLANNING ANALYTICS (TM1)
Version: 2.0.6
Excel Version: Excel for office 365
Location: SOUTH AFRICA

Email Notifications for a Tm1 Application

Post by DYNA »

Hi guys.

On a Tm1 Application, there is a requirement in our business which states that the manager must be notified on a certain date which budgets haven't been submitted.

We are using an Approval Hierarchy application type, and our current business structure/hierarchy is as follows:
-> Cluster (Highest level)
-> Department
-> Branch
-> Business Unit (Lowest Level)

For example, the Branch manager must be notified on a certain date, via email, which business units haven't submitted.

Is this possible to achieve?
Paul Segal
Community Contributor
Posts: 312
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: Email Notifications for a Tm1 Application

Post by Paul Segal »

Yes, quite possible. Look here https://exploringtm1.com/sending-emails ... m1-part-1/, or search on the internet. You'll need to have the manager's email addresses stored somewhere, a manager specified per Business Unit and a submission date for each Business Unit (unless it's a standard date for all Business units. Then write a TI to send an email to the specified manager if the submission date has passed.
Paul
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Email Notifications for a Tm1 Application

Post by macsir »

If your server is on Windows, then just call in-built Send-MailMessage function from Powershell. It has all functions you need and no need to install other software.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply