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 » Thu Jul 27, 2017 1:08 pm

Hi all,
is python is used in Planning analytics(10.3)??

MariusWirtz
Posts: 1
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 » Thu Jul 27, 2017 5:13 pm

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 » Sun Jul 30, 2017 12:22 pm

Tq marius,can you tell me the difference between tm1s.cfg file and tm1p.ini file. Thanks in advance

ellissj3
Posts: 53
Joined: Tue Jun 15, 2010 1:43 pm
OLAP Product: Cognos TM1
Version: 9.0 - 10.2
Excel Version: 2010
Contact:

Re: is python is used in Planning analytics

Post by ellissj3 » Mon Jul 31, 2017 1:40 pm

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 » Wed Oct 11, 2017 3:53 am

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: 1298
Joined: Wed May 28, 2008 9:09 am

Re: is python is used in Planning analytics

Post by David Usherwood » Wed Oct 11, 2017 2:32 pm

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 » Thu Oct 12, 2017 12:18 am

Ok thanks
I will give it a try

Post Reply