TM1 Forum

Hello TM1 Forum, The community‑driven TM1 project built over the past decade by 50 + contributors, including many regulars of this forum, has been shortlisted for the IBM TechXchange Excellence in Open Source award. Community voting is open until  August 22, 2025. If you’d like to support TM1py, you...

Currently there is no very elegant way to specify additional custom HTTP headers that TM1py should send with each request to TM1. However, you can manipulate the HEADERS dictionary in the RestService class that maintains the default set of headers that TM1py uses. If you do this before you initiate ...

That example is not entirely accurate. In TM1py, you can execute existing TI processes like this: https://gist.github.com/MariusWirtz/999a0f37edac11a26dc8cff8560437fa#file-tm1py-execute-with-return-py You can also execute "unbound" TI processes. That means your process is immediately execu...

If you are using v12 on MCSP, this should work. Just substitute the 3 placeholders with their appropriate values. [tm1srv01] base_url=https://us-east-1.planninganalytics.saas.ibm.com/api/<TenantId>/v0/tm1/<DatabaseName>/ user=apikey password=<TheActualApiKey> async_requests_mode=True ssl=True verify...

Now that IBM is moving v12 instances to MCSP, the TM1py authentication looks slightly different. Here is an example of how to connect to TM1 v12 on MCSP. If you substitute the 3 placeholders <TenantId>, <DatabaseName>, <TheActualApiKey>, it should just work. from TM1py import TM1Service params = { &...

Hi everyone, We just released TM1py 2.0. You can find all the details here: https://github.com/cubewise-code/tm1py/releases/tag/2.0 Among many other things, this release offers - support for TM1 v12 - performance improvements - new functions to update dimensions or clear a cube directly from a data ...

Hi Ajit,

To get started on TM1py, I can recommend this training.
https://edu.cubewise.com/training-tm1py-fundamentals/

I also recommend familiarizing yourself with the basics of Python.
This YouTube tutorial covers all the basics in the first few hours.
https://www.youtube.com/watch?v=nLRL_NcnK-4

Hi Mark we just completed the work for TM1 v12 (PAaaS) the other week, with special thanks to Ryan, the main developer behind this feature. https://github.com/cubewise-code/tm1py/pull/1000 We plan to draft a release in a week or two. To get the functionality now, you can already upgrade to the curre...

I can't reproduce the error. Two questions: - Are you using the latest version of OptimusPy? - Do you have the same folder structure locally as in the project? You need to download the folder as it is in the project here: https://github.com/cubewise-code/optimus-py So the "optimuspy.py" fi...

You can upgrade RushTI to resolve this issue.

Please post questions regarding RushTI here:
https://github.com/cubewise-code/rushti/issues

Hi everyone, on Friday we released TM1py 1.11. You can find all details here: https://github.com/cubewise-code/tm1py/discussions/901 This release closes the performance gap in write speed between TM1py and Turbo Integrator. All new features are backward compatible and all upgrades should be free of ...

You have my vote

Starting this year we will offer "TM1Py Support by Cubewise". I want to announce this quickly myself as well as answer a couple of questions people might have to avoid any misunderstandings. TL/DR: TM1Py Support by Cubewise in no way compromises the open-source nature of the project. ▶ Why...

Hi, are you connecting to TM1 on-cloud or PA on-premise? If you are using TM1 on-premise, what IntegratedSecurityMode are you using? For TM1 on cloud you can use this article as a reference. https://code.cubewise.com/tm1py-help-content/connecting-to-the-ibm-cloud-remotely-with-tm1py For TM1 on cloud...

Hi everyone, today we released TM1py 1.10. You can find all details here: https://github.com/cubewise-code/tm1py/discussions/811 The release includes all improvements and bug fixes that have been done since February this year! I would encourage everyone to upgrade. All the new stuff is backward comp...

Thanks, Wim!

Totally agree. We would want to exclude empty cells! Thanks for the fix.

Hi, instead of using a macro and the PAX API, you could also use a py script to read the column values from excel and add the elements to the dimension with TM1py. Here is a sample in case you are interested: import openpyxl from TM1py import TM1Service excel_products = set() wb = openpyxl.open(&quo...

Hi everyone,

We released TM1py 1.9 this week You can find an overview of the new release here:
https://github.com/cubewise-code/tm1py/discussions/685

Hi, I can confirm that one can process through a cubeview/MDX more efficiently with a TI than one could do with REST/TM1py. Somehow TI doesn't materialize the full view in Memory before consuming it. In the REST world it works differently. It's essentially a two-step process. 1. First, one executes ...

We just released TM1py 1.8

You can find an overview of the new release here:
https://github.com/cubewise-code/tm1py/ ... /tag/1.8.0

I hope this will be useful to the TM1 community.