TM1 Forum

Discussing all things TM1, Planning Analytics, PAx and PAW
https://www.tm1forum.com/

TM1 Loggers on what websheet has been opened by who and when

https://www.tm1forum.com/viewtopic.php?t=14808

Page 1 of 1

TM1 Loggers on what websheet has been opened by who and when

Posted: Thu Aug 08, 2019 3:17 am
by yyround
Hi All,

Can you tell me whether there is a TM1 logger that logs the info of what websheet has been opened by who and when?

We don't have pulse but wondering how does pulse tracks that?

Thank you so much
YY

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Thu Aug 08, 2019 7:18 am
by macsir
https://www-01.ibm.com/support/docview. ... wg21980348
I just built a tracking cube for that. Very useful.

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Thu Aug 08, 2019 7:32 am
by lotsaram
Pulse doesn't use the log4j loggers for TM1Web. It has it's own logging mechanism which writes to the Pulse database.

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Thu Aug 08, 2019 8:45 am
by Wim Gielis
macsir wrote: ↑Thu Aug 08, 2019 7:18 am https://www-01.ibm.com/support/docview. ... wg21980348
I just built a tracking cube for that. Very useful.
Thanks. I updated the properties file and I see new content being logged.
However, is it possible to have a setting such that the username is logged when a websheet or view is accessed ? That would be more useful for filtering, summary stats (who is using the application, when, how long, what tasks, ...)

Thank you.

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Thu Aug 08, 2019 12:26 pm
by yyround
Thank you so much macsir :)

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Thu Aug 08, 2019 7:58 pm
by macsir
Wim Gielis wrote: ↑Thu Aug 08, 2019 8:45 am
macsir wrote: ↑Thu Aug 08, 2019 7:18 am https://www-01.ibm.com/support/docview. ... wg21980348
I just built a tracking cube for that. Very useful.
Thanks. I updated the properties file and I see new content being logged.
However, is it possible to have a setting such that the username is logged when a websheet or view is accessed ? That would be more useful for filtering, summary stats (who is using the application, when, how long, what tasks, ...)

Thank you.
Yes, it is possible.
log4j.logger.com.ibm.cognos.tm1.web.services=DEBUG
you will see username, when to login, when to open websheet or view, or even which tab in the websheet was accessed. Very detailed. :D

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Fri Aug 09, 2019 12:58 pm
by Wim Gielis
macsir wrote: ↑Thu Aug 08, 2019 7:58 pmYes, it is possible.
log4j.logger.com.ibm.cognos.tm1.web.services=DEBUG
you will see username, when to login, when to open websheet or view, or even which tab in the websheet was accessed. Very detailed. :D
Hello macsir,

Thanks but after starting the TM1 Web application and with this as the contents of the properties file, I get information on my usernam about the login, I get information on the filename that is opened. But nothing about the sheet name, nor in the same neighborhood the information that it is my username who opens the said file.

PAL 2.0.8

Would it be possible to provide the contents of your entire properties file please ?

Code: Select all

# System logging settings
log4j.rootLogger=ERROR, TextFile
log4j.logger.com.ibm.cognos=ERROR
log4j.logger.com.cognos=ERROR
log4j.logger.com.cognos.org=ERROR
log4j.logger.com.ibm.cognos.perf=ERROR
log4j.logger.com.ibm.cognos.tm1=ERROR
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ExportService=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1Service=INFO
log4j.logger.com.ibm.cognos.tm1.publish.Workbook=DEBUG 
log4j.logger.com.ibm.cognos.tm1.web.clientcontext=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ServerSessionInfo=DEBUG

log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p (%x) %c - %m%n

log4j.appender.TextFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.TextFile.File=logs/tm1web.log
log4j.appender.TextFile.DatePattern=.yyyy-MM-dd
log4j.appender.TextFile.layout=org.apache.log4j.PatternLayout
log4j.appender.TextFile.layout.ConversionPattern=%d [%t] %-5p (%x) %c - %m%n

log4j.appender.XMLFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.XMLFile.File=logs/tm1web_log.xml
log4j.appender.XMLFile.DatePattern=.yyyy-MM-dd
log4j.appender.XMLFile.layout=org.apache.log4j.xml.XMLLayout

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Fri Aug 09, 2019 8:22 pm
by ssharma
I've had these ones in my environment and they gave me the active form/websheet name along with the number of records it generated which helps to pin point the cause of the web server memory spike but did not tell me "Who" ran it. It only captured user information upon login.

log4j.logger.com.ibm.cognos.tm1.web.services.TM1ExportService=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1Service=INFO
log4j.logger.com.ibm.cognos.tm1.publish.Workbook=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ServerSessionInfo=DEBUG
log4j.logger.com.ibm.cognos.tm1.datasource.javaapi.TM1CubeView=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.session.HttpSessionListener=DEBUG
log4j.logger.com.ibm.cognos.tm1.websheet.ActiveFormView=DEBUG
log4j.logger.com.ibm.cognos.tm1.websheet.WorkbookContainer=INFO
log4j.logger.com.ibm.cognos.tm1.websheet.parser.ExcelReader=DEBUG

But looks like PA 2.0.8 also has a new logger that is supposed to answer all 3 questions - Who/What/When along with the number of records.I am yet to try this out though.

https://www.ibm.com/support/knowledgece ... gging.html

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Fri Aug 09, 2019 9:33 pm
by Wim Gielis
With the additional loggers, in 2.0.8, I get indeed more information in the logging.
Thanks a lot for your first post in 5 years time, but it's a good one :-)

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Sun Aug 11, 2019 10:38 pm
by macsir
Wim Gielis wrote: ↑Fri Aug 09, 2019 12:58 pm
macsir wrote: ↑Thu Aug 08, 2019 7:58 pmYes, it is possible.
log4j.logger.com.ibm.cognos.tm1.web.services=DEBUG
you will see username, when to login, when to open websheet or view, or even which tab in the websheet was accessed. Very detailed. :D
Hello macsir,

Thanks but after starting the TM1 Web application and with this as the contents of the properties file, I get information on my usernam about the login, I get information on the filename that is opened. But nothing about the sheet name, nor in the same neighborhood the information that it is my username who opens the said file.

PAL 2.0.8

Would it be possible to provide the contents of your entire properties file please ?

Code: Select all

# System logging settings
log4j.rootLogger=ERROR, TextFile
log4j.logger.com.ibm.cognos=ERROR
log4j.logger.com.cognos=ERROR
log4j.logger.com.cognos.org=ERROR
log4j.logger.com.ibm.cognos.perf=ERROR
log4j.logger.com.ibm.cognos.tm1=ERROR
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ExportService=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1Service=INFO
log4j.logger.com.ibm.cognos.tm1.publish.Workbook=DEBUG 
log4j.logger.com.ibm.cognos.tm1.web.clientcontext=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services=DEBUG
log4j.logger.com.ibm.cognos.tm1.web.services.TM1ServerSessionInfo=DEBUG

log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p (%x) %c - %m%n

log4j.appender.TextFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.TextFile.File=logs/tm1web.log
log4j.appender.TextFile.DatePattern=.yyyy-MM-dd
log4j.appender.TextFile.layout=org.apache.log4j.PatternLayout
log4j.appender.TextFile.layout.ConversionPattern=%d [%t] %-5p (%x) %c - %m%n

log4j.appender.XMLFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.XMLFile.File=logs/tm1web_log.xml
log4j.appender.XMLFile.DatePattern=.yyyy-MM-dd
log4j.appender.XMLFile.layout=org.apache.log4j.xml.XMLLayout
It is just this extra line with original log property file.
Yes, the log content is not very straight forward but need a bit analysis. From user name, you can find session token and that matches the session id when the user entering the workbook. From there, you will find the object id of the workbook. With object id, you can find index id(worksheet seq number, starting from 0) when the user switching the tab. You already know the timestamp for each action above, then you can capture all these info into the cube. Hope it helps.

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Thu Mar 19, 2020 10:22 pm
by macsir
Ironically, the if you have any DEBUG in your log4j file in PAL 2.0.8, then you can't export to PDF/slice/snapshot any web report.
This is a known bug.

PI98421 SINCE PLANNING ANALYTICS, EXPORT FROM TM1 WEB GIVES WEBPAGE ERROR IF DEBUG IS ENABLED
from this link https://www.ibm.com/support/pages/ibm-p ... -lists#208

Re: TM1 Loggers on what websheet has been opened by who and when

Posted: Fri Mar 20, 2020 9:45 am
by HighKeys
Thanks

+1 from me, searched something like that :)
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited