Product:

Planning Analytics 2.0.9.13

Problem:

How log user login to tm1?

Solution:

Create a file named tm1s-log.properties in same folder as the tm1s.cfg, with this content:

log4j.logger.TM1=INFO, S1
log4j.logger.TM1.Lock=ERROR, S1
log4j.appender.S1=org.apache.log4j.SharedMemoryAppender
log4j.appender.S1.MemorySize=10 MB
log4j.appender.S1.MaxFileSize=100 MB
log4j.appender.S1.MaxBackupIndex=20
log4j.appender.S1.TimeZone=local

log4j.logger.TM1.Login=DEBUG, S2
log4j.additivity.TM1.Login=false
log4j.appender.S2=org.apache.log4j.SharedMemoryAppender
log4j.appender.S2.File=TM1login.log
log4j.appender.S2.MaxFileSize=100 MB
log4j.appender.S2.MaxBackupIndex=20
log4j.appender.S2.TimeZone=local

Will create a tm1login.log file in your log folder. It will contain the user name for IntegratedSecurityMode=1.

If it is a CAM user you may have to read the }TM1_DefaultDisplayValue in }Clients dimension.

 

 

Then you can use this code to load the log file into a cube;

https://github.com/ykud/sample_tm1_tis/blob/main/SYS%20TM1Login%20Update.pro

More Information:

https://exploringtm1.com/using-tm1-log-files/

https://blog.octanesolutions.com.au/changing-password-in-multiple-tm1-instances

https://code.cubewise.com/blog/ibm-tm1-and-planning-analytics-cheatsheet

https://everanalytics.wordpress.com/2021/02/17/tm1-rest-api-example/

https://github.com/cubewise-code/tm1py/issues/393

https://github.com/cubewise-code/tm1py-samples/blob/master/Administration/list_tm1_users