What is TM1py?

TM1py is a Python package that wraps the TM1 REST API in a simple to use library. That makes it easy to build stuff with TM1 and python.

Python is a widely-used general-purpose programming language that lets you work quickly and integrate systems more effectively.

Why you should use it?

  • Use Pandas for Data Analysis and Statistics on top of your TM1 model.

  • Build Machine Learning and Forecasting Algorithms with Python and scikit-learn based on your TM1 data.

  • Load data (e.g. FX, stock data) from web services into TM1 such as Quandl financial.

Do more with your IBM TM1 and Planning Analytics application

  • Do stuff across different TM1 instances (e.g. reschedule all chores on all instances by -1 hour, synchronize cubes throughout TM1 instances)

  • Get insights from your TM1 model. (e.g. Which views use this subset?, which process has an ODBC Datasource?)

  • Export TM1 data to XML, JSON, YAML, XLSX, …

  • Bring Regular Expressions, Lists, Dictionaries, Classes, Functions and all kind of programming concepts to the TM1 world, that make your life easier as a developer.

  • Run TM1 processes and write to TM1 in parallel.

  • Generate MDX Queries from cube views.

Built with TM1py

50+ ready-to-use samples, try them out.

Final logos_Rushti.png

Run processes in parallel using only one connection

A super calculator for IBM TM1 and Planning Analytics.


All of the code, documents and information in TM1py are to be deemed without warranty.


The source code is hosted at github.com/cubewise-code/tm1py. 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.