Planning Analytics

 View Only
  • 1.  TM1 Rest API with Google Sheets

    Posted Tue November 23, 2021 05:54 AM
    Great work by Jim Naf!

    Integrating TM1 with Google Sheets using the Rest API
    Linkedin remove preview
    Integrating TM1 with Google Sheets using the Rest API
    The following are sample Google Scripts I put together based on the Planning Sample TM1 model. These scripts will show how I was able to integrate Google Sheet data with IBM.
    View this on Linkedin >


    ------------------------------
    paul YOUNG
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: TM1 Rest API with Google Sheets

    Posted Thu December 09, 2021 09:11 AM
    Hey Paul, have you heard about **TeamOne** Google Sheets add-on: https://succeedium.com/teamone
    https://workspace.google.com/marketplace/app/teamone/112725458607

    It comes with TEAMONE formula to pull data from TM1 server. You can configure multiple TM1 connections, import\export data from/to TM1, manage TM1 users, permissions, cubes, views, dimensions, subsets, processes, compare and deploy code, search TM1 model, see logs, TM1 model doc etc.

    The great thing it can be used even with a free gmail account. 
    We have 300+ TM1 users, 3 TM1 models and 5 tm1 environments and this is a HUGE lifesaver

    ------------------------------
    Vlad Didenko
    ------------------------------