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

Post Reply
yyround
Posts: 24
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: PA2.0.6
Excel Version: MS 2016

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

Post by yyround » Thu Aug 08, 2019 3:17 am

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

User avatar
macsir
Community Contributor
Posts: 638
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

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

Post by macsir » 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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

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

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

Post by lotsaram » Thu Aug 08, 2019 7:32 am

Pulse doesn't use the log4j loggers for TM1Web. It has it's own logging mechanism which writes to the Pulse database.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

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

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

Post by Wim Gielis » 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.
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 service with AutoHotKey

yyround
Posts: 24
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: PA2.0.6
Excel Version: MS 2016

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

Post by yyround » Thu Aug 08, 2019 12:26 pm

Thank you so much macsir :)

User avatar
macsir
Community Contributor
Posts: 638
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

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

Post by macsir » Thu Aug 08, 2019 7:58 pm

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
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

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

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

Post by Wim Gielis » Fri Aug 09, 2019 12:58 pm

macsir wrote:
Thu Aug 08, 2019 7:58 pm
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
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
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 service with AutoHotKey

ssharma
Posts: 1
Joined: Mon Aug 25, 2014 8:23 pm
OLAP Product: TM1
Version: PA 2.0.2
Excel Version: 2013

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

Post by ssharma » Fri Aug 09, 2019 8:22 pm

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
MVP
Posts: 2109
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis » Fri Aug 09, 2019 9:33 pm

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 :-)
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 service with AutoHotKey

User avatar
macsir
Community Contributor
Posts: 638
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

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

Post by macsir » Sun Aug 11, 2019 10:38 pm

Wim Gielis wrote:
Fri Aug 09, 2019 12:58 pm
macsir wrote:
Thu Aug 08, 2019 7:58 pm
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
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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

Post Reply