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
- Aug 11: How IPG Leverages SAP BusinessObjects Analysis, Edition for Microsoft Office, to Deliver Winning Analytics and Increase Usability
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.
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.
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
Thank you! 🙂
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
Michael - thank you for noticing the response in my blog. I forgot to loop back to you here. I will look at your idea
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