SAP Knowledge Base Article - Preview

3085993 - Troubleshooting guide for the SAP Analytics Cloud, add-in for Microsoft Office

Symptom

This document provides some guidance on how to troubleshoot issues when using the SAP Analytics Cloud (SAC), add-in for Microsoft Office (Excel) and how to find the correct SAP product area (component) to report product issues (if necessary).

  1. Check the online help section SAP Analytics Cloud, add-in for Microsoft Office Troubleshooting & FAQ.
  2. Make sure everything is in place according to the online help section System Requirements and Technical Prerequisites and that the tenant is configured correctly referring to SAP KBA 3255665 - SAP Analytics Cloud tenant configuration and troubleshooting.
  3. Compare the scenario using the same model directly in the SAC web interface.

Most of the scenarios using the SAP Analytics Cloud, add-in for Microsoft Office (add-in) can be tested by creating a story directly in the SAC web interface to determine whether the issue is related to the add-in or with SAC.

Please follow the steps below:

    1. Log into the SAC web client with a supported browser (Client Software Requirements).
    2. From the Main Menu/navigation bar, select Stories.
    3. Create a new canvas story.
    4. Add a table object (widget) to the story
    5. Select an acquired (import) planning or analytic type model.
    6. Follow the same navigational steps that are followed using the SAP Analytics Cloud, add-in for Microsoft Office to reproduce the issue.

Some of the scenarios are listed below:

  • Issue related to unexpected/wrong data.
  • Errors when retrieving data from a model or after a navigational step (e.g. filter, drilldown, etc.).
  • Poor or slow performance.

Is the issue reproducible when creating a story directly in the SAC web interface?

  • If yes: Create an incident by selecting component LOD-ANA-DES.
  • If no: Check the next section (4) and then create an incident by selecting component LOD-ANA-OF (if necessary).
  1. If the issue only occurs in the SAP Analytics Cloud, add-in for Microsoft Office, see below depending on the scenario:

Logon issues when trying to access the SAC system from the SAP Analytics Cloud (SAC), add-in for Microsoft Office:

Performance issues

  1. Logs & Traces

Web version of Excel (Online)

All browsers offer development tools (most of them open by pressing F12 or CTRL+Shift+I), where it is possible to watch the network traffic, check the memory consumption or check the browser console for errors.

Windows Excel (Desktop App)

    1. Right-click anywhere in the SAP Analytics Cloud panel and click on the "Inspect" button as shown below:
      Inspect.png

    2. Click the Console tab in the developer tools window:
      Console.png

    3. Reproduce the issue and check the Console tab for any errors.

Apple Mac OS Excel

Refer to the Microsoft documentation "Debug Office Add-ins on a Mac" for more information about how to configure Excel Mac to see console logs and traces.

  1. Information required when opening an incident with SAP

After determining whether the issue is related to the SAP Analytics Cloud, add-in for Microsoft Office or when creating an incident by selecting component LOD-ANA-OF, please provide the following information:

  • Provide a clear step-by-step document showing how to reproduce the issue.
  • Provide screenshots of the errors shown in the browser developer tools (DevTools) (see above).
  • If the issue occurs when using an existing workbook, attach a copy of the workbook to the incident. Make sure it is not saved as "Read Only".
  • Follow the steps in SAP KBA 3200458 to make sure that SAP can create a support user for reproduction purposes.
  • Provide the SAC tenant tenant URL and also make sure you select the correct SAC system when creating the incident.
  • Provide the platform used (e.g. MAC or Windows, desktop or web, version number).
  • Provide the browser (e.g. Chrome, Edge)
  • How was the SAP Analytics Cloud, add-in for Microsoft Office deployed and installed in Excel (provide some screenshots, if applicable).


Read more...

Environment

  • SAP Analytics Cloud, add-in for Microsoft Office
  • SAP Analytics Cloud (Enterprise)

Product

SAP Analytics Cloud 1.0 ; SAP Analytics Cloud, add-in for Microsoft Office all versions

Keywords

sac, add-in, addon, tenant, cloud, office, Troubleshooting guide for SAC, add-in for MS Office, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, System Requirements and Technical Prerequisites. MS MSOffice , KBA , connecting to prod tenant tes t , excel add in not connecting to prod tena , connecting to excel add in client excel , excel add in issue , sac production domain test , changed test prod dev qa environment , excel add-in for sap analytics cloud sac , LOD-ANA-OF , SAP Analytics Office , LOD-ANA-OF-MS , SAP Analytics Cloud, add-in for Microsoft Office , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.