Search found 5 matches

by MariusWirtz
Mon Jun 03, 2019 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 470

Re: RunTI Issue

Hi mce, I wrote a tool for exactly the use case that you are describing: RushTI It allows you to execute a list of processes with a fix number of threads at the same time, while using only one session. That means it Authenticates only once at the start and re-uses the session. You can download the l...
by MariusWirtz
Tue Mar 05, 2019 10:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: consolidated elements without children
Replies: 8
Views: 486

Re: REST API: consolidated elements without children

This should do the trick:

Code: Select all

/api/v1/Dimensions('plan_business_unit')/Hierarchies('plan_business_unit')/Members?$select=Name&$expand=Element($select=Type),Children/$count&$filter=Element/Type eq 3 and Children/$count eq 0
by MariusWirtz
Mon Jan 07, 2019 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 4076

Re: TM1 REST API

Hi Wim, the 5 points that you brought up here could be accomplished with TM1py through very little custom code. This is how I would approach it. # 1 Print out summary of a cube view from TM1py import TM1Service with TM1Service(address='10.77.19.60', port=12354, user='admin', password='apple', ssl=Tr...
by MariusWirtz
Mon Mar 26, 2018 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: export an Application via Script (TM1 Api)
Replies: 13
Views: 1817

Re: export an Application via Script (TM1 Api)

Yes. You can use TM1py to load a TM1 (Excel-) Application into python. Once you have it in python you can save it as an xlsx file or do something else with it. Here is a sample how to load a TM1 Excel Application and save it into a file: https://github.com/cubewise-code/TM1py-samples/blob/master/Oth...
by MariusWirtz
Thu Jul 27, 2017 5:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: is python is used in Planning analytics
Replies: 6
Views: 2276

Re: is python is used in Planning analytics

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 Pyth...