3698282 - Analysis Office SSO not working after downloading a workbook from Business Planning and Consolidation(BPC) even if the SSO enabled between AO and backend system

After downloading the AO workbook via BPC when reopen the local workbook, the logon credentials are asked although the SSO works between AO and backend system.

SAP Analysis for Microsoft Office

1. Download a AO workbook from BPC and save as local file in PC.
2. Reopen the local workbook in AO directly.
3. The login dialogue pops up and credentials are asked.

From AO version 2.8 SP11, the connection framework has been refactored to make AO’s connections to the various data providers more robust and faster, as a consequence, in some workflows existing workbooks required adjustment or a specific setting needed to be enabled.

• Set the AO setting UseSingleConnectionPerDestination to true as described in SAP Note 3083429, the download workbook will then use the connection information from SAP GUI to enable SSO, regardless the SSO status persisted in the workbook.
• Set ForceRefreshConnectionInfo to true will also resolve the issue.

• SAP Note 3293372 - Analysis Office SNC / SSO Not Working - Asks for Username and Password
• SAP Note 2083067 - How to maintain settings for Analysis Office
  
  

SAP Business Planning and Consolidation Plug-in, Web, logon dialogue, logon window, appear, SNC, BPF , KBA , BI-RA-AO-XLA , Excel Addin , Problem