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
Run TI via tm1py
-
- Posts: 63
- Joined: Thu Jul 03, 2014 1:14 pm
- OLAP Product: cognos
- Version: 10.2.2
- Excel Version: 2010
-
- 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
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
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
-
- 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
You can use tm1runti or use ProcessService class from tm1py.
-
- 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
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
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
-
- 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
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.
Code: Select all
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)
Code: Select all
-
- 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
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.
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.