We are in the process of setting up our new BO4 environments and we will be integrating BO with the SAP Netweaver Portal, so our users will log on to the Portal and then open up a tab that will display the BI Launch Pad logging on to BO with SAP SSO into SAP BW.
This works great, but now some of our users will be using Analysis for Microsoft Excel and the question has come up, how do they authenticate to BO. Since they will have a user id in BW, but no password set since it is all SSO with logon tickets, how can they authenticate themself?
FWe have SSO working for Analysis for Excel.
First you have to replicate the BW user IDs to BOE and assign proper rights.
Second all OLAP connections are set to SSO (authentication 2).
Basis has to generate keystore and import the BO certificate.
Sounds like you are talking about Advanced Analysis and not Analysis for MS Office. We got SSO between BO and BW which allows users to run BICS connections under their own user id's. But I'm asking how does Analysis for MS Office, which is a client install get authenticated to BusinessObjects/BW without users entering a password.
We will be testing the way SAP says it should work shortly and I'll update this post accordingly.
the Admin guide for this product has these steps.
please refer to section
6.2 Authentication and single sign-on Regards,
6.2 Authentication and single sign-on
I did the steps described within the manual.
It works when accesing the BW directly from BI launchpad (SSO with AD, SAP SSO set up, no additional SAP authentiaction is neccessary).
If I try to use the connection via aaoffice, (logged to BO (also with AD SSO ) opening the same OLAP connection, I still get asked for user/password.
Can you please help?
Patch BO4 SP2 P19 should cover that behaviour, but i have switched to BO 4SP4 before the patch was released so I wasn't able to test that.
The problem only occurs when I use AD sso to authenticate to bo Platform.
If the user logs on via AD manually it works as intended without SSO in Analysis,
THe problem still exists in SBOP 4SP4
Thanks for the quick reply.
I am using BI 4 SP02 Patch 16.
My requirement is when a user log in the BI launch pad using SAP authentication and opens a Workbook stored in BO repository Analysis prompts again to enter userid and password.
I need to achieve SSO at this level so that user only log in to BI Launch pad and should be able to log in Analysis tool for excel directly. Is this possible?
We have also never been able to get SSO for the Office Analysis tool to work as advertised. SSO is working everywhere but for that tool. We are on BO 4 SP4 as well. Tool has never worked. Users are getting very frustrated, but all SAP ever does is ask for screenshots and log files from the PC...
Has anyone gotten this to work?
Hi Look for SAP Note 1768868 - What is SAP Business Objects Analysis and what SSO options are available ?
"There are two ways of using SSO with Analysis for MS OFFICE :
- Using the Analysis for Excel tool directly on a client machine using SNC (SNC needs to installed and configured on each client)
- Integrating Analysis for Office tools with Business Objects.
In this scenario, the Analysis for Excel reports are being saved in the Launchpad/Infoview.
The users login to the Infoview using the SAP login ID or any 3rd Party authentication method like Windows AD or LDAP. Then they open the reports with SSO enabled.
In order to achieve SSO with Business Objects BI 4.0, the following criteria must be met :
- SSO should be configured properly for Business Objects BI 4.0 for SAP authentication.
- In the CMC under OLAP Connections the parameter Authentication is set to SSO for the BW systems that should be used with Single Sign-On.
- With BI 4.0, the user doesn't need to own a user account in the BW system. They can use the login credential embedded with the data source in Analysis. "