TM1py is the python package for IBM Planning Analytics (TM1).

with TM1Service(address='localhost', port=8001, user='admin', password='apple', ssl=True) as tm1:
    subset = Subset(dimension_name='Month', subset_name='Q1', elements=['Jan', 'Feb', 'Mar'])
    tm1.subsets.create(subset, private=True)

Features

TM1py offers handy features to interact with TM1 from Python, such as

Functions to read data from cubes through cube views or MDX queries (e.g. tm1.cells.execute_mdx)
Functions to write data to cubes (e.g. tm1.cells.write)
Functions to update dimensions and hierarchies (e.g. tm1.hierarchies.get)
Functions to update metadata, clear or write to cubes directly from pandas dataframes (e.g. tm1.elements.get_elements_dataframe)
Async functions to easily parallelize your read or write operations (e.g. tm1.cells.write_async)
Functions to execute TI process or loose statements of TI (e.g. tm1.processes.execute_with_return)
CRUD features for all TM1 objects (cubes, dimensions, subsets, etc.)

Requirements

Python (3.7 or higher)
TM1/Planning Analytics (v11 or higher)

Optional Python Packages

pandas
networkx

Install

without pandas

pip install tm1py

with pandas

pip install "tm1py[pandas]"

Usage

TM1 11 on-premise

from TM1py.Services import TM1Service

with TM1Service(address='localhost', port=8001, user='admin', password='apple', ssl=True) as tm1:
    print(tm1.server.get_product_version())

TM1 11 on IBM cloud

with TM1Service(
        base_url='https://mycompany.planning-analytics.ibmcloud.com/tm1/api/tm1/',
        user="non_interactive_user",
        namespace="LDAP",
        password="U3lSn5QLwoQZY2",
        ssl=True,
        verify=True,
        async_requests_mode=True) as tm1:
    print(tm1.server.get_product_version())

TM1 12 PAaaS

from TM1py import TM1Service

params = {
    "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": True
}

with TM1Service(**params) as tm1:
    print(tm1.server.get_product_version())

TM1 12 on-premise & Cloud Pak For Data

with TM1Service(
        address="tm1-ibm-operands-services.apps.cluster.your-cluster.company.com",
        instance="your instance name",
        database="your database name",
        application_client_id="client id",
        application_client_secret="client secret",
        user="admin",
        ssl=True) as tm1:

    print(tm1.server.get_product_version())

TM1 12 on-premise with access token

params = {
    "base_url": "https://pa12.dev.net/api/<InstanceId>/v0/tm1/<DatabaseName>",
    "user": "8643fd6....8a6b",
    "access_token":"<TheActualAccessToken>",
    "async_requests_mode": True,
    "ssl": True,
    "verify": True
}

with TM1Service(**params) as tm1:
    print(tm1.server.get_product_version())

Documentation

https://tm1py.org/

Issues

If you find issues, sign up in GitHub and open an Issue in this repository

Contribution

TM1py is an open source project. It thrives on contribution from the TM1 community. If you find a bug or feel like you can contribute please fork the repository, update the code and then create a pull request so we can merge in the changes.

Release files for TM1py 2.4.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for TM1py 2.4.1
File	Size	Uploaded
tm1py-2.4.1.tar.gz	181.3 kB	Sep 21, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for TM1py 2.4.1
File	Interpreter	ABI	Platform	Reset
tm1py-2.4.1-py3-none-any.whl 209.4 kB Sep 21, 2026	Python 3	none	any	Details

Total release size: 390.7 kB

Release files / tm1py-2.4.1.tar.gz

Download URL	tm1py-2.4.1.tar.gz
Size	181.3 kB
Tags	Source
SHA-256 checksum How to use checksums	`0ddcb68fd3e5781085297b0bceeea0cc577bed8e7e26bebea99a73d9d02f1711`
BLAKE2b-256 checksum How to use checksums	`76e1cf78425b7a8923859b9cde98f395ca673d079a01c24b337a1913fbf0ef5f`
Upload date	Sep 21, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/7.0.0 CPython/3.11.16`

Release files / tm1py-2.4.1-py3-none-any.whl

Download URL	tm1py-2.4.1-py3-none-any.whl
Size	209.4 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`d666f89a656ea1f245a766a4a60db50d293cade31635c41c4effc9ab972f8d81`
BLAKE2b-256 checksum How to use checksums	`6047dea4e7ab87f1fe50cac0c9e0c89109a5d00fb8912c57135da81a70f6a317`
Upload date	Sep 21, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/7.0.0 CPython/3.11.16`