User Inactivity Timeout - What Constitutes an 'Action' in Excel?

[KeithC]

We currently have our 'User Inactivity Timeout' setting to 30 minutes. We have users that are being 'timed out' in the excel add-in before that time threshold. 

Question- What constitutes an 'action' for HSGET formulas or Quick Views that would reset the 30 minute timeout?

- Refreshing a sheet with no change in Metadata selections?

- Refreshing a sheet with just HSGET formulas?

Thank you!

[JJones · Accepted solution]

Refreshing the sheet should reset the 30 minute timeout setting for User Inactivity Timeout.  The user inactivity timeout would be tied to a user who has not had any action on an application server in the environment for 30 minutes.  In order to count as an action, it would just be a request that was submitted to the application server, a Sheet Refresh would count as a call to the application server even if the metadata was not changed on the sheet as it has received a call to retrieve the data again.

As a test I set User Inactivity Timeout to 10 minutes and created an excel sheet with a cube view connection.  I left excel for 10 minutes and then came back and refreshed and my session was timed out.  

I then logged back in and refreshed the sheet and then set a timer for 10 minutes and before 10 minutes I refreshed the sheet and then went back when it would have been the 10 minute expiration and I was still logged in.

Hope that helps answer your question.