Any tm1web log setting to get user access websheet info

Post Reply
Niko
Posts: 50
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

Any tm1web log setting to get user access websheet info

Post by Niko »

I want to know websheet is opened by user how much times,but tm1web can not find these information,i am confused,anyone can help me ,thank u first.
burnstripe
Regular Participant
Posts: 197
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: Any tm1web log setting to get user access websheet info

Post by burnstripe »

Here's a link to another thread on the topic.
https://www.tm1forum.com/viewtopic.php?t=14808

The tm1web logs can produce this information such as who accessed what websheet and when. After changing the Log4j properties you'll then need to parse through the file to extract the information you need
Niko
Posts: 50
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

Re: Any tm1web log setting to get user access websheet info

Post by Niko »

burnstripe wrote: Sat Sep 02, 2023 7:47 pm Here's a link to another thread on the topic.
https://www.tm1forum.com/viewtopic.php?t=14808

The tm1web logs can produce this information such as who accessed what websheet and when. After changing the Log4j properties you'll then need to parse through the file to extract the information you need
i will research that, try to use TI parse file. thank u ver much
User avatar
gtonkin
MVP
Posts: 1202
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: Any tm1web log setting to get user access websheet info

Post by gtonkin »

Here's another reference that may help: Using TM1 Web logging

Edit: and another that looks useful Include user names and memory usage in TM1 Web logs
The following information is included in logs:
Timestamp
Application and Active Form name
Number of rows that were generated
User name
Current heap memory after the websheet renders
Niko
Posts: 50
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

Re: Any tm1web log setting to get user access websheet info

Post by Niko »

gtonkin wrote: Sun Sep 03, 2023 1:31 pm Here's another reference that may help: Using TM1 Web logging

Edit: and another that looks useful Include user names and memory usage in TM1 Web logs
The following information is included in logs:
Timestamp
Application and Active Form name
Number of rows that were generated
User name
Current heap memory after the websheet renders
thank u ver much. I will deep into research your attach article.
lotsaram
MVP
Posts: 3654
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Any tm1web log setting to get user access websheet info

Post by lotsaram »

Niko wrote: Sat Sep 02, 2023 4:59 pm I want to know websheet is opened by user how much times,but tm1web can not find these information,i am confused,anyone can help me ,thank u first.
If you are lucky enough to have Pulse, and it is properly configured then Pulse captures this information and it can be reported.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Niko
Posts: 50
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

Re: Any tm1web log setting to get user access websheet info

Post by Niko »

lotsaram wrote: Wed Sep 06, 2023 11:03 am
Niko wrote: Sat Sep 02, 2023 4:59 pm I want to know websheet is opened by user how much times,but tm1web can not find these information,i am confused,anyone can help me ,thank u first.
If you are lucky enough to have Pulse, and it is properly configured then Pulse captures this information and it can be reported.
I am surprised how pulse complete that :D
Post Reply