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.
Export list of System Names
-
- Posts: 28
- Joined: Wed Aug 08, 2018 10:01 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2016
-
- MVP
- Posts: 1815
- 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
You can get them from the }externals folder in your data directory.
Declan Rodger
-
- MVP
- Posts: 3651
- 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
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.
-
- Posts: 28
- 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
Is there any way to access it if I don't have access to the data directory? I can only use Perspectives.
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Export list of System Names
With a fair amount of TI code probably... But whether it's efficient is far from unsure
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly