is python is used in Planning analytics

Post Reply
siva8142
Posts: 7
Joined: Wed May 03, 2017 1:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

is python is used in Planning analytics

Post by siva8142 »

Hi all,
is python is used in Planning analytics(10.3)??
MariusWirtz
Posts: 29
Joined: Sat Apr 08, 2017 8:40 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: 2016

Re: is python is used in Planning analytics

Post by MariusWirtz »

Hi,

no, PA doesn't support the Python programming language natively.

The Planning Analytics Server (TM1) has a REST API though. It's powerful and ligthning fast.
So you can relatively easily do Python stuff with your Planning Analytics model.

In case you want to do that, we built an open source Python wrapper around the TM1 REST API.
https://github.com/MariusWirtz/TM1py

It makes things a lot easier and it's (almost entirely) documented and tested.

Happy python-ing! Cheers,

Marius
vinod
Posts: 4
Joined: Tue Mar 21, 2017 10:45 am
OLAP Product: IBM TM1
Version: 10.2.2
Excel Version: Excel2013

Re: is python is used in Planning analytics

Post by vinod »

Tq marius,can you tell me the difference between tm1s.cfg file and tm1p.ini file. Thanks in advance
ellissj3
Posts: 54
Joined: Tue Jun 15, 2010 1:43 pm
OLAP Product: Cognos TM1
Version: 9.0 - 10.2
Excel Version: 2010

Re: is python is used in Planning analytics

Post by ellissj3 »

Vinod,

This should be a different thread, and it does not follow the posting guidelines.

TM1S.CFG - Server configuration file which dictates the operations of the TM1 server itself

TM1P.INI - User configuration file
george_apo
Posts: 3
Joined: Mon Apr 23, 2012 1:02 pm
OLAP Product: Planning analytics
Version: 2.0.26 (Cloud)
Excel Version: 2016
Location: Australia

Re: is python is used in Planning analytics

Post by george_apo »

Hi,
did anyone manage to use python to connect to planning analytics (cloud) with single sign on, via the REST API?
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: is python is used in Planning analytics

Post by David Usherwood »

I have been working with Marius and with Jason Kapp to adjust TM1PY to work with TM1 SaaS. Marius has released a new version which should handle this but I have not yet tested it myself. I suggest you download it and try, and let him know at https://github.com/cubewise-code/TM1py how you get on - we'd all be interested :)
george_apo
Posts: 3
Joined: Mon Apr 23, 2012 1:02 pm
OLAP Product: Planning analytics
Version: 2.0.26 (Cloud)
Excel Version: 2016
Location: Australia

Re: is python is used in Planning analytics

Post by george_apo »

Ok thanks
I will give it a try
Post Reply