Hey Paul, have you heard about **TeamOne** Google Sheets add-on:
https://succeedium.com/teamonehttps://workspace.google.com/marketplace/app/teamone/112725458607It 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
------------------------------
Original Message:
Sent: Tue November 23, 2021 05:54 AM
From: paul YOUNG
Subject: TM1 Rest API with Google Sheets
Great work by Jim Naf!
Integrating TM1 with Google Sheets using the Rest APILinkedin | 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