Search found 4 matches

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: 327

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: 3623

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: 1674

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: 2140

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