Tips – Loading data into TM1 with Python via TM1py

TM1py opens up the TM1 Server to more data sources outside of your company’s network that can be used to provide extra insight to your analysis. Would you like to load the weather forecast to identify products that should be central to the coming week’s advertising plan or load exchange rates to better predict the cash flow?

Using the power of Python, TM1py can help make this a reality for your TM1 model. Learn how to utilise this technology with an interview from Marius Wirtz, the creator of TM1py.

Key takeaways:

  • Get started with TM1py with this step by step tutorial (link)
  • Learn how to upload exchange rates (link)
  • Download TM1py on Github

Recorded at the Cubewise EDU TM1 and Planning Analytics User Conference in Sydney 2019.


3 thoughts on “Tips – Loading data into TM1 with Python via TM1py

    • Bryan Wan says:

      You need to instantiate the TM1Service with the base_url argument and credentials for a non-interactive account:
      tm1 = TM1Service(base_url=’https://[Customer_Name][Server Name]/’, user='[non-interactive username]’, password=’non-interactive user password’, namespace=’LDAP’, ssl=[your ssl option, try False first])

      Here you can find more details about it:

Leave a Reply

Your email address will not be published. Required fields are marked *