export an Application via Script (TM1 Api)

Post Reply
Nitrel
Posts: 11
Joined: Fri Oct 08, 2010 9:40 pm
OLAP Product: TM1
Version: all Versions
Excel Version: all Versions

export an Application via Script (TM1 Api)

Post by Nitrel » Fri Mar 23, 2018 10:53 am

Is it possible to export an already published application inside TM1 Application Web (Version PA 2.0.3) using a script (TM1 API)?
Hope someone here have an idea how this can be possible

Chris

MariusWirtz
Posts: 2
Joined: Sat Apr 08, 2017 8:40 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: 2016

Re: export an Application via Script (TM1 Api)

Post by MariusWirtz » Mon Mar 26, 2018 11:25 am

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

Marius

Nitrel
Posts: 11
Joined: Fri Oct 08, 2010 9:40 pm
OLAP Product: TM1
Version: all Versions
Excel Version: all Versions

Re: export an Application via Script (TM1 Api)

Post by Nitrel » Wed Apr 11, 2018 1:24 pm

@MariusWirtz

Thanks a lot for this very nice answer

User avatar
tomok
MVP
Posts: 2412
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: export an Application via Script (TM1 Api)

Post by tomok » Wed Apr 11, 2018 3:58 pm

Nitrel wrote:
Wed Apr 11, 2018 1:24 pm
@MariusWirtz

Thanks a lot for this very nice answer
You do realize that all this is going to do is give you the Excel file, with whatever contents were in it when it was published. Correct? If that's all you want why not just grab it from the }Externals folder in the data directory?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Post Reply