Run TI via tm1py

Post Reply
Mithun.Mistry1103
Posts: 63
Joined: Thu Jul 03, 2014 1:14 pm
OLAP Product: cognos
Version: 10.2.2
Excel Version: 2010

Run TI via tm1py

Post by Mithun.Mistry1103 »

Hello all

Some advise if possible please, trying to run TI processes from desktop. Has anyone written any python code or is there any other technology ie batch used that will allow us to execute TM 1 processes from server or from device?

Any ideas?


Thank you
Wim Gielis
MVP
Posts: 3222
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Run TI via tm1py

Post by Wim Gielis »

Maybe show us the code you already have with explanations what it should be doing and why it does not work - if possible.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Emixam
Regular Participant
Posts: 155
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: Run TI via tm1py

Post by Emixam »

You can use tm1runti or use ProcessService class from tm1py.
Wim Gielis
MVP
Posts: 3222
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Run TI via tm1py

Post by Wim Gielis »

Or run them from PAfE. Or from any scripting language using the TM1 REST API.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Mithun.Mistry1103
Posts: 63
Joined: Thu Jul 03, 2014 1:14 pm
OLAP Product: cognos
Version: 10.2.2
Excel Version: 2010

Re: Run TI via tm1py

Post by Mithun.Mistry1103 »

An example I found was this and this would be something Id be looking to work with as a start of a 10
from TM1py import Process
from TM1py.Services import TM1Service

process = Process(name="dim.Oracle could update - MASTER")
success, status, error_log_file = tm1.processes.execute_process_with_return(process)
if success:
print("Process executed successfully")
else:
print("Process execution failed. Status: " + status + ". Path to error log file: " + error_log_file) Just a script allowing me to run a savedataall process by executing this either from my desktop screen or from the server.
MariusWirtz
Posts: 32
Joined: Sat Apr 08, 2017 8:40 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: 2016

Re: Run TI via tm1py

Post by MariusWirtz »

That example is not entirely accurate.

In TM1py, you can execute existing TI processes like this:

https://gist.github.com/MariusWirtz/999 ... -return-py

You can also execute "unbound" TI processes.
That means your process is immediately executed in TM1 but never actually created. This can be useful if you need to call an exotic TI function that is not natively available in REST API / TM1py.

Here is an example:

https://gist.github.com/MariusWirtz/1c1 ... 3e92fdab74

In your example, you are sort of mixing both approaches. That shouldn't work.
Post Reply