Export list of System Names

Post Reply
jamesbennett
Posts: 21
Joined: Wed Aug 08, 2018 10:01 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2016

Export list of System Names

Post by jamesbennett » Fri Aug 23, 2019 3:56 pm

The documentation (https://www.ibm.com/support/knowledgece ... b0f65.html) describes that to generate a hyperlink to an application, one should "use the Properties pane to find the System Name" (point 1).

Is there any way to export a list of system names for all applications? I want to be able to just copy all and paste into Excel but that doesn't seem to be an option.

declanr
MVP
Posts: 1628
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Export list of System Names

Post by declanr » Fri Aug 23, 2019 4:06 pm

You can get them from the }externals folder in your data directory.
Declan Rodger

lotsaram
MVP
Posts: 3317
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Export list of System Names

Post by lotsaram » Fri Aug 23, 2019 8:09 pm

declanr wrote:
Fri Aug 23, 2019 4:06 pm
You can get them from the }externals folder in your data directory.
Or within the }Applications folder you open the .blob file corresponding to the application entry and open it with a text editor and the ENTRYREFERENCE property contains the hyperlink with the system name from }Externals. I think this is the easier route.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

jamesbennett
Posts: 21
Joined: Wed Aug 08, 2018 10:01 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2016

Re: Export list of System Names

Post by jamesbennett » Tue Aug 27, 2019 8:11 am

Is there any way to access it if I don't have access to the data directory? I can only use Perspectives.

Wim Gielis
MVP
Posts: 2258
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Export list of System Names

Post by Wim Gielis » Tue Aug 27, 2019 9:40 am

With a fair amount of TI code probably... But whether it's efficient is far from unsure ;-)
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

Post Reply