Hi,
TM1 development is moving more and more to PAW, well in theory anyway!
One of the key tools when developing or sorting out issues is to asciioutput the results. As far as I know you can only output to a drive that the TM1 server has access to.
Given that PAW is a web based tool, and more than likely to be accessed from a users local machine, I think it would be useful to ascii to the local machine, rather than the TM1 server.
Anyone have any thoughts on this, or are their existing ways to make it possible?
Maren
Asciioutput to users local machine
- Steve Rowe
- Site Admin
- Posts: 2415
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Asciioutput to users local machine
Yup...
#Get the logging directory (Delivered with a trailing slash)
sLogDirPath = GetProcessErrorFileDirectory;
#write the file
asciioutput(sLogDirPath | 'tm1myerror.log', etc....)
Any file that starts tm1 and ends .log will show up in the download logs dialogue on the PAW admin page of the TM1 DB.
Simple when you know how, but some experimentation was required!
#Get the logging directory (Delivered with a trailing slash)
sLogDirPath = GetProcessErrorFileDirectory;
#write the file
asciioutput(sLogDirPath | 'tm1myerror.log', etc....)
Any file that starts tm1 and ends .log will show up in the download logs dialogue on the PAW admin page of the TM1 DB.
Simple when you know how, but some experimentation was required!
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- gtonkin
- MVP
- Posts: 1198
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Asciioutput to users local machine
I use two different approaches:
1 - Drill to the text file
2 - Email the resulting file based on the logged in user. ExecuteCommand in epilog to run the necessary ps script
Where files are big, FTP or RDP to the rich client are options for admins with relevant access.
1 - Drill to the text file
2 - Email the resulting file based on the logged in user. ExecuteCommand in epilog to run the necessary ps script
Where files are big, FTP or RDP to the rich client are options for admins with relevant access.
-
- Regular Participant
- Posts: 349
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: Asciioutput to users local machine
Hi,
thanks for the feedback, very interesting solutions that I will test at some point!
Still like logging onto the server and just opening from the directory, but good to see the available options and they do have other uses.
Maren
thanks for the feedback, very interesting solutions that I will test at some point!
Still like logging onto the server and just opening from the directory, but good to see the available options and they do have other uses.
Maren
-
- MVP
- Posts: 3113
- 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: Asciioutput to users local machine
If it’s an IBM cloud environment, the SFTP access with e.g. FileZilla is very easy.
Similar solutions can probably be set up for other systems.
Why not just READ access to the TM1 logging directory through a mapped network drive ?
Similar solutions can probably be set up for other systems.
Why not just READ access to the TM1 logging directory through a mapped network drive ?
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
- vovanenok
- Posts: 88
- Joined: Mon Jun 23, 2014 4:54 pm
- OLAP Product: TM1
- Version: 2.0.9
- Excel Version: Office 365
- Location: Toronto, Canada
- Contact:
Re: Asciioutput to users local machine
For smaller logs, I would just use LogOutput()
Then you can search the logs using TM1 REST API (or check TeamOne in the commercial subforum: https://www.tm1forum.com/viewforum.php?f=20)
Another option is to write logs to a custom cube
I also like the drill to file solution proposed by George and mapped network drive proposed by Wim
Then you can search the logs using TM1 REST API (or check TeamOne in the commercial subforum: https://www.tm1forum.com/viewforum.php?f=20)
Another option is to write logs to a custom cube
I also like the drill to file solution proposed by George and mapped network drive proposed by Wim