Skip to Content
author's profile photo Former Member
Former Member

Is there a Time-out for Excel Users

Is there a way to time-out Excel users who logon to an application, then don't do anything, for say a half hour or an hour? Or a user logs on through Excel and sends data, but doesn't logoff. Can the user be timed out after some time being inactive?

Thanks.

Edited by: Nancy Eichinger on Jul 25, 2008 1:01 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 08:27 AM

    Nancy,

    I think there is no possibility to do this in SAP-BPC. Sadly ... I think other systems can not do this also (Cognos, Hyperion,FDC...)

    But it is not such a problem because when you are connected but doing nothing the server is not "active": You do not send request to it!

    Nic

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 12:26 PM

    There is no "Time-Out" mechinism. It is a feature that we have looked at building, but as it is pointed out, using BPC for Excel is not a connected view all the time. Since BPC leverages the Excel components, it is really acting as if you ONLY opened Excel; only difference is the toolbars, panes, and connections to the back-end. We have had customers also ask for this feature, but once they realize that that BPC is a Tool and not a connected system, it is not a critical "must have" need. But, any suggestions you have will be noted, but enhancements should also be submit through the Customer Service Center using a ticket request.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 02:09 PM

    Thanks for helping me understand this. The question came up because there is a concern that alot of users will connect and do some work, but not logoff (because they use Excel for many functions) causing resources on the web/app server or SQL/AS server to be unavailable to other users. For example, a user sends data or does a retrieve and is done, but doesn't log off, are resources "tied up" on either server because of that? Thanks!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Data Sends and retrievals happen upon execution. Once the execution finishes, the only thing the client does is ping the server to make sure the connections are there and ready for any new queries. Other than that, and as far as I am aware, the fact that Excel is open has no ill effect on the Server and its operation, ie no resources are tied up, rather checked on by the client.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 06:20 PM

    I'll pass this info along... Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.