Skip to Content
Author's profile photo Tammy Powlas

Trying out the SAP Logoff API – Analysis Office 2.1

In the What’s New document it states “The API method SAPLogOff is new. You can use it to disconnect a workbook from the server or to restart the

connection to the system.”  The SAP Early Knowledge Transfer materials say “Allows to log off or log on again, e.g. for refreshing newly entered master data (for planning)”

Even though I am not using planning, I thought I would try it out.

Here is the initial analysis:


On the Developer tab for Analysis, I insert a button and place the code “Application.Run (“SAPLogOff”) as shown below:


When I click the “Logoff” button, the display panel disappears.


I made a change on the backend, and click refresh all ribbon (without leaving the workbook) and it refreshes as below:


If you are interested in learning more join ASUG this Wednesday for Analysis Office and EPM Add-in Convergence webcast.


Upcoming ASUG BI Webcast Listing – includes

Add these SAP Lumira Sessions at #SABOUC ASUG Conference in Austin

ASUG Pre-Conference Seminars at SAP TechEd Las Vegas

ASUG is offering an all-day, hands-on session with design studio on October 19 at SAP TechEd Las Vegas – more information can be found here.

The ASUG education sessions for SAP TechEd have not been announced yet, but will include customer stories about SAP BusinessObjects Design Studio. Register today.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Michael Hamm
      Michael Hamm

      Hi Tammy,

      i am wondering why there is only an API? Do you know if a real log on/off button is coming for the final release of 2.1?

      For me it looks like that SAP can now say "We delivered the most wanted, missing BEX-feature", but the customers are not really satisfied, because they don't want to insert this button in dozens of workbooks.



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Michael - thank you for reading and commenting

      I don't have any knowledge if such a button will be added in final 2.1 release; I will try to ask in the ASUG webcast on Wednesday

      Author's profile photo Michael Hamm
      Michael Hamm

      Thank you! 🙂

      Author's profile photo Michael Hamm
      Michael Hamm

      It's a pity that there will be only an API for Log on/Off and not a GUI button.

      I created an idea as this does not satisfy our needs. I hope there will be more customers  who vote for the idea.

      Add GUI Button for Log on/off : View Idea

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Michael - thank you for noticing the response in my blog. I forgot to loop back to you here. I will look at your idea

      Author's profile photo Torsten Wirth
      Torsten Wirth

      There are problems in combination with BO and SSO this feature does not work. You are getting invalid session errors:

      Advanced COM API via VBA