Planning Analytics

Hi,

We are evaluating to migrate our on-prem PA to IBM PA on Cloud 2.0.9.12. We were told that Tm1RUnTI (trigger TI in child instance from master TM1 instance) will not be available on Cloud and also, we can't use ExecuteCommand TI function to call any Windows batch scripts to do any basic operations like emailing, housekeeping etc.

Please let us know if there is any alternate way available on the cloud for the above. 

------------------------------
Jaganathan C P
------------------------------

Hi,

I think the information you were given relates to PA aaS (i.e. V12 on cloud)

For my customers on V11 using PA on Cloud we definitely use both TM1RunTI and ExecuteCommand.

The only consideration in the near future with the rich tier environment being deprecated is running the encryption tool to encrypt passwords to be used with the non-interactive account for TM1RunTI.

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg
------------------------------

Original Message:
Sent: Thu July 11, 2024 05:09 PM
From: Jaganathan C P
Subject: Planning Analytics on Cloud

Hi,

We are evaluating to migrate our on-prem PA to IBM PA on Cloud 2.0.9.12. We were told that Tm1RUnTI (trigger TI in child instance from master TM1 instance) will not be available on Cloud and also, we can't use ExecuteCommand TI function to call any Windows batch scripts to do any basic operations like emailing, housekeeping etc.

Please let us know if there is any alternate way available on the cloud for the above. 

------------------------------
Jaganathan C P
------------------------------

I can confirm that TM1RunTi is still supported and can be run from Planning Analytics on Cloud.  It will continue to work even with the upcoming deprecation of the rich client tier systems.  

As a reminder, if the use case is to start one or more TI processes from a TI process (to run asynchronously) from the same TM1 database then you should use the RunProcess TI function.  Using ExecuteCommand and TM1RunTi together is only required when running a TI process on a different TM1 database that the database using the ExecuteCommand TI function.  In TM1 v12 it's very easy to run a TI process on a remote database with the new ExecuteHTTPRequest TI function (instead of ExecuteCommand and TM1RunTi).

George, thanks for pointing out the detail about the tm1crypt.exe functionality.  

------------------------------
Stuart King
IBM Planning Analytics Offering Manager
------------------------------

Original Message:
Sent: Fri July 12, 2024 01:26 AM
From: George Tonkin
Subject: Planning Analytics on Cloud

Hi,

I think the information you were given relates to PA aaS (i.e. V12 on cloud)

For my customers on V11 using PA on Cloud we definitely use both TM1RunTI and ExecuteCommand.

The only consideration in the near future with the rich tier environment being deprecated is running the encryption tool to encrypt passwords to be used with the non-interactive account for TM1RunTI.

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg

Original Message:
Sent: Thu July 11, 2024 05:09 PM
From: Jaganathan C P
Subject: Planning Analytics on Cloud

Hi,

We are evaluating to migrate our on-prem PA to IBM PA on Cloud 2.0.9.12. We were told that Tm1RUnTI (trigger TI in child instance from master TM1 instance) will not be available on Cloud and also, we can't use ExecuteCommand TI function to call any Windows batch scripts to do any basic operations like emailing, housekeeping etc.

Please let us know if there is any alternate way available on the cloud for the above. 

------------------------------
Jaganathan C P
------------------------------

Regarding TM1RunTI on Planning Analytics on Cloud see the IBM technote

https://www.ibm.com/support/pages/how-use-tm1runti-cloud
How to use TM1RunTI on Cloud

Summary
Specific account and steps need to be performed in order to use TM1RunTI on IBM Planning Analytics on Cloud. This document described these steps.

------------------------------
Bernd Siebert
------------------------------

Original Message:
Sent: Thu July 11, 2024 05:09 PM
From: Jaganathan C P
Subject: Planning Analytics on Cloud

Hi,

We are evaluating to migrate our on-prem PA to IBM PA on Cloud 2.0.9.12. We were told that Tm1RUnTI (trigger TI in child instance from master TM1 instance) will not be available on Cloud and also, we can't use ExecuteCommand TI function to call any Windows batch scripts to do any basic operations like emailing, housekeeping etc.

Please let us know if there is any alternate way available on the cloud for the above. 

------------------------------
Jaganathan C P
------------------------------

Regarding ExecuteCommand on Planning Analytics on Cloud there is a thread from 2021

https://community.ibm.com/community/user/businessanalytics/discussion/what-are-you-using-executecommand-for-in-the-cloud-we-want-to-hear-from-you
What are you using ExecuteCommand for in the Cloud? We want to hear from you.

------------------------------
Bernd Siebert
------------------------------

Original Message:
Sent: Thu July 11, 2024 05:09 PM
From: Jaganathan C P
Subject: Planning Analytics on Cloud

Hi,

We are evaluating to migrate our on-prem PA to IBM PA on Cloud 2.0.9.12. We were told that Tm1RUnTI (trigger TI in child instance from master TM1 instance) will not be available on Cloud and also, we can't use ExecuteCommand TI function to call any Windows batch scripts to do any basic operations like emailing, housekeeping etc.

Please let us know if there is any alternate way available on the cloud for the above. 

------------------------------
Jaganathan C P
------------------------------