IBM Planning analytics for Excel Session Time out

[PrabhjotSinghPhull]

Hi Team

three tier architecture i.e PAW in one server, CA in one server and PA in one server.

Windows server 2019
Paw version-2.0.80

I have referred the below article:

Step 1: navigated to PA sever path and opened the tm1web_config.xml as notepad.
Step 2: Added the parameter as HttpSessionTimeout = 15mins.

PAW_forum.png (10.25 KiB) Viewed 2114 times

(refer the attached screenshot)

Result: opened the excel connected with server idle waited for 15 mins but the excel is not throwing error for session time out.

Refernces used :
Planning Analytics Spreadsheet Services (new TM1 Web):
Default: 20 minutes (default session-timeout in \tm1web\webapps\tm1web\WEB-INF\web.xml)
Location: \tm1web\webapps\tm1web\WEB-INF\configuration\tm1web_config.xml
Setting: HttpSessionTimeout
https://www.ibm.com/support/knowledgece ... meout.html

Please assist on this issue.

Regards
Prabhjot Singh

[Steve Rowe]

Hi,
Your mail is rather unclear about which client session you are trying to impact.

You mention editing a config for PASS but then mention testing the connection time out in Excel.

For excel sessions you want the following both set in the tm1s.cfg
https://www.ibm.com/docs/en/planning-an ... outseconds
and
https://www.ibm.com/docs/en/planning-an ... outminutes

[PrabhjotSinghPhull]

Hi Steve

i have tired and added the parameter but its not working the session for excel is not getting timed out.
please do let me know if i need to try something else.

Screenshot 2024-06-05 124629.png (22.96 KiB) Viewed 2024 times