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

[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

[macsir]

https://www-01.ibm.com/support/docview. ... wg21980348
I just built a tracking cube for that. Very useful.

[lotsaram]

Pulse doesn't use the log4j loggers for TM1Web. It has it's own logging mechanism which writes to the Pulse database.

[Wim Gielis]

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.

[yyround]

Thank you so much macsir

[macsir]

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.

[Wim Gielis]

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.

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

[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

[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

[macsir]

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.

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.

[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

[HighKeys]

Thanks

+1 from me, searched something like that