Skip to Content
avatar image
Former Member

SSO with Analysis for MS Excel?

Hi,

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?

Thanks

Josh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 05, 2012 at 01:16 PM

    Hi there,

    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.

    Et voila!

    Cheers

    Sven

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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?

      Regards,

      Pulkit Khare

  • Aug 17, 2012 at 06:11 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Look for SAP Note 1768868 - What is SAP Business Objects Analysis and what SSO options are available ?

      Resume:

      "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. "

      Regards,

      Marco Modesto

  • avatar image
    Former Member
    Jan 17, 2012 at 01:25 PM

    That's a good question! We are having the same issue. Anyone with a solution?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Spoke with SAP on this and they said that if we set up normal SNC for SAP GUI the Analysis for Excel will utilise that and you will have SSO. We are still to try it so I'm not saying this will work. Anyone else looked at this yet?

  • avatar image
    Former Member
    Jul 31, 2012 at 12:07 AM

    Anybody was able to get this working?

    If yes please share the steps..

    Regards,

    Pulkit Khare

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2014 at 05:39 AM

    Hi Josh,

    I am experiencing the same issue. Kindly share the resolution, please?

    Cheers!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 26, 2016 at 02:21 PM

    So, there is a solution for this or not? i understand that you could have sso working on bi launchpad, but what about analysis for office? there is any chance of loggin without credentials? i mean not only to connect with bw or hana to select a datasource but also to connect to BO system in first place.

    Thank and regards.

    Add comment
    10|10000 characters needed characters exceeded

  • May 01 at 06:16 PM

    Analysis for Office can SSO to BI only if BI is integrated with kerberos. If using BW data Aoffice can actually connect directly to BW using SNC just like SAP GUI, if SSO works in SAP GUI it should work for Aoffice, in this case you essentially bypass BI.

    Add comment
    10|10000 characters needed characters exceeded