Hi,
I would be interested in experience of TM1 deployment on Mac client machines.
I assume these should work:
- web
- contributor
I assume these do not work (even if Excel for Mac is in use):
- perspectives
- architect
- Insight
- CAFE
I would be happy to hear about any experience.
Thanks!
TM1 clients on Mac
-
macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: TM1 clients on Mac
Well, I think the only possible workable part is TM1 web on Mac Client although I have not tried to access them from mac.
-
macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: TM1 clients on Mac
Well, I think the only possible workable part is TM1 web on Mac Client although I have not tried to access them from mac.
-
BrianL
- MVP
- Posts: 264
- Joined: Mon Nov 03, 2014 8:23 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2 PA2
- Excel Version: 2016
Re: TM1 clients on Mac
Officially, TM1 supports "TM1 Application Web and TM1 Web only" with "Firefox browser only" on Mac.
See http://www-01.ibm.com/support/docview.w ... wg27043712 for more details.
See http://www-01.ibm.com/support/docview.w ... wg27043712 for more details.
-
mvaspal
- Community Contributor
- Posts: 341
- Joined: Wed Nov 03, 2010 9:16 pm
- OLAP Product: tm1
- Version: 10 2 2 - 2.0.5
- Excel Version: From 2007 to 2013
- Location: Earth
Re: TM1 clients on Mac
Thanks a lot, that was my assumption tooOfficially, TM1 supports "TM1 Application Web and TM1 Web only" with "Firefox browser only" on Mac.
However it would be still good to hear about real experiences if there are any
Re: TM1 clients on Mac
Quick update for anyone landing on this thread today looking for a Mac-friendly way to get TM1 data into Excel.
The reason Perspectives and PAfE don't work on Mac Excel is architectural — they're COM add-ins, and COM doesn't exist on macOS. That hasn't changed. What has changed is that Microsoft's Office.js Web Add-in framework runs natively on Excel for Mac, Excel for Windows, and Excel on the web from a single codebase, and the Custom Functions API on top of it lets vendors register cross-platform =MYNS.MYFUNC() formulas.
Disclosure: I'm with ForQuest Solutions and we ship PAXcel, a TM1/PA Excel Web Add-in built on Office.js — it's on Microsoft AppSource. Custom functions cover the usual TM1 patterns (=PAXCEL.GET, =PAXCEL.VIEW, =PAXCEL.SEND, =PAXCEL.SUBSET, =PAXCEL.ATTR, =PAXCEL.SERVER), and because it's Office.js the same workbook opens identically on Mac and Windows. Per-user TM1 security still applies, and it works against both on-prem Planning Analytics and PA Cloud.
Happy to answer questions from anyone evaluating it for a Mac-heavy team.
— Rick Stevenson, ForQuest Solutions
The reason Perspectives and PAfE don't work on Mac Excel is architectural — they're COM add-ins, and COM doesn't exist on macOS. That hasn't changed. What has changed is that Microsoft's Office.js Web Add-in framework runs natively on Excel for Mac, Excel for Windows, and Excel on the web from a single codebase, and the Custom Functions API on top of it lets vendors register cross-platform =MYNS.MYFUNC() formulas.
Disclosure: I'm with ForQuest Solutions and we ship PAXcel, a TM1/PA Excel Web Add-in built on Office.js — it's on Microsoft AppSource. Custom functions cover the usual TM1 patterns (=PAXCEL.GET, =PAXCEL.VIEW, =PAXCEL.SEND, =PAXCEL.SUBSET, =PAXCEL.ATTR, =PAXCEL.SERVER), and because it's Office.js the same workbook opens identically on Mac and Windows. Per-user TM1 security still applies, and it works against both on-prem Planning Analytics and PA Cloud.
Happy to answer questions from anyone evaluating it for a Mac-heavy team.
— Rick Stevenson, ForQuest Solutions