SAP Knowledge Base Article - Public

2713637 - Connection between SAP Analysis for Office (AO) and SAP Analytics Cloud (SAC) can't be established

Symptom

  • Loading data from SAP Analytics Cloud (SAC) does not work when trying to integrate SAC with SAP Analysis for Microsoft Office (AO).
  • After setting up a connection and providing logon credentials, SAP Analytics Cloud appears prompting/warning that IE is not a supported browser and the logon screen does not disappear.
  • When closing this window manually, the following error is observed in AO: Error during logon (CANCELED_BY_USER).
  • Problem is related to SAC systems running on non-SAP datacenters (CF).

Environment

  • SAP Analytics Cloud
  • SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Create a connection in SAP Analysis for Microsoft Office according to the official user's guide.
  2. When you load the connection, provide SAC user credentials.
  3. Logon window does not close automatically but warns that a not supported browser is being used.

Cause

There is an issue when AO is trying to read the saplogon.ini file but SAP GUI is using SAPUILandscape.xml instead of saplogon.ini.

Resolution

There was an initial logon issue which has been fixed in SAP Analysis for Office 2.7 Service Pack 2.

  • See 2609982 - Analysis Office 2.7: Release Note for SP 02

In case the issue still exists and you are using SAPUILandscape.xml:

  1. Navigate to Excel > Analysis > Customize Analysis > Technical Configuration.
  2. Search for "UseSapUILandscapeComApi".
  3. Disable/uncheck it.
  4. Restart Excel.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, IE, supported, browser, AO, analysis, office ,excel , KBA , question related to sap analytics cloud, , add-in for microsoft office kba , sap analysis for ms office 365 (the exce , the excel plugin , BI-RA-AO-XLA , Excel Addin , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0