3706945 - Checkpoints: Excel issues in SAP Analytics Cloud, add-in for Microsoft Excel

Symptom

Help document for SAP Analytics Cloud, add-in for Microsoft Excel
Release Plan
Trouble-shooting steps
Errors:
1. Go button is grayed out
2. go! button disabled
3. panel is empty
4. blank screen, blank window
5. add-in is outdated
6. connection failed when VPN enabled
7. HTTP status code: Forbidden" when trying to configure the SAC tenant in PowerShell
8. Get-OrganizationAddInOverrides: There was an error retrieving Add-Ins
9. There was an error uploading the Add-in AddInOverridesCreationException
10. live data source not found
11. connection slow
12. add-in crash due to memory limit
13. add-in restart
14. cannot access workbook
15. Comments are not supported for this table since it has dimensions with members exceeding the admin configured limit; please contact your administrator
16. An error occurred while loading the data sources of system <systemname>. Therefore, no data sources can be shown.
How to trace in Excel add-in

Environment

SAP Analytics Cloud, add-in for Microsoft Office
SAP Analytics Cloud, add-in for Microsoft Excel

Cause

Missing Configurations
Network Disruption like VPN or Azure Service
Missing Functions

Resolution

System Requirement
1. SAC: System Requirements and Technical Prerequisites
2. Microsoft: Technical Prerequisites for using the add-in
Online Help
1. SAP Analytics Cloud:
  1. Microsoft Office Integration
2. SAP Analytics Cloud, add-in for Microsoft Excel
  1. SAP Analytics Cloud, add-in for Microsoft Excel
  2. System Requirements and Technical Prerequisites
3. Microsoft Excel
4. Microsoft 365
  1. Microsoft recommends moving interactive devices to Monthly Enterprise Channel or Current Channel.
  2. Semi-Annual Enterprise Channel is shifting to focus on unattended devices.
  3. 3597802 - How to check the current release of Microsoft 365 Apps
  4. See "Important Section":
    1. https://learn.microsoft.com/en-us/microsoft-365-apps/best-practices/switch-to-monthly-enterprise-channel
Trouble-Shooting
1. Check if domains is accessible in cooperation network (for example: [assets.sapanalytics.cloud appsforoffice.microsoft.com hcs.cloud.sap])
  1. Check Firewall
  2. Check Proxy configuration
  3. Check VPN
2. Check Azure disruption:
  1. Check Current Status: https://azure.status.microsoft/en-us/status/
  2. Review history:https://azure.status.microsoft/en-us/status/history/
3. Check Tenant Configuration
  1. Check if it is Admin user that runs add-in deployment in Powershell
    1. related error: HTTP status code: Forbidden" when trying to configure the SAC tenant in PowerShell
    2. Deploy and publish the add-in as administrator
  2. Check Tenant Domain:
    1. tenant URL with the standard domain hcs.cloud.sap can be used without any additional configuration
    2. tenant URL with domain sapanalytics.cloud and hanacloudservices.cloud.sap must be manually configured by Microsoft365 administrator
    3. see Tenant Configuration
  3. Tenant Configuration related error:
    1. AppDomain Configuration
      1. See Step 5 in 3255665 - SAP Analytics Cloud tenant configuration and troubleshooting
    2. Get-OrganizationAddInOverrides: There was an error retrieving Add-Ins
    3. How to Test:
      1. Open the PowerShell and connect to your Microsoft365 tenant by running the command Connect-OrganizationAddInService and authenticate with a Microsoft365 administrator
      2. Run the following command: Get-OrganizationAddInOverrides -ProductId 8a512e2b-c04e-4c06-9235-11b6cd59f584
      3. Confirm that the affected SAC tenant URL(s) is listed in "AppDomains" in the output
        see sample in 3255665 - SAP Analytics Cloud tenant configuration and troubleshooting
4. Check if trusted origins sites are configured in SAC tenant:
  1. go to SAC tenant and choose System Administration - App Integration - Trusted Origins.
  2. make sure the following sites as trusted origins:
    https://hcs.cloud.sap
    https://*.live.com
    https://*.online.office.de
    https://*.sharepoint.com
  3. Related Error: go! button disabled
5. Check if Excel Cache is reset:
  1. After deployment, please reset the add-in cache:
    1. Windows:
      1. Close all your Microsoft 365 apps, especially Outlook.
      2. Open Excel and go to File - Options - Trust Center - Trust Center Settings... - Trusted Add-in Catalogs .
      3. In Trusted Web Add-in Catalogs, select the check box Next time Office starts, clear all previously-started web add-ins cache.
      4. Close Excel and restart it to clear the add-in cache.
      5. After the restart, the check box is deselected automatically.
    2. Mac:
      1. 3616922 - How to delete SAP Analytics Cloud, add-in cache on Mac
6. Local Browser:
  1. Check if third-party cookies are blocked:
    1. related error: builder panel empty
7. Check User Authorization:
  1. Tenant Level: SAC Related Authorization:
    1. Object: transaction data:
      1. SAC: Privileges and Permissions
      2. SAC: User
      3. SAC: Role
      4. SAC: Audit log:
        Data Change
        Activity
    2. Object: Excel workbook:
      1. User needs to have Add-in Workbook permission configured in SAC tenant - Security
  2. Excel Level: Excel Workbook Authorization:
    1. Designer: all permissions: Create, Read and Update
    2. Viewer: Read permission assigned
    3. give designer permissions to viewers via workbook preferences
    4. read-only workbook: sample
      1. Allow editing in the Share dialog
  3. See more Permissions for the add-in
8. Functions:
  1. General Trouble-Shooting Rule:
    1. Check if the issue is reproducible via SAC Story
      1. If so, report the case under SAC functions
      2. If the issue is reproducible only with Excel add-in function, then report the case under SAP Analytics Cloud, add-in for Microsoft Excel
  2. Data Point Comment
    1. SAP.GETDATACOMMENT
    2. Limit: Go to System ->Administration > System configuration -> Enable commenting on models with dimension members limit
      1. Related Error: Comments are not supported for this table since it has dimensions with members exceeding the admin configured limit; please contact your administrator
  3. Transaction Data:
    1. Planning data with the add-in, see help
    2. Analyze and Plan with Formulas, see help
    3. Analyzing Data, see help
  4. Live Connections:
    1. Related Error:
      1. An error occurred while loading the data sources of system <systemname>. Therefore, no data sources can be shown.
        3511880 Error occurs when connecting SAP BW or SAP S/4HANA Tunnel type Live connection in SAC add-in for Microsoft Excel
9. Traces:
  1. Windows:
    1. Browser - Inspect:
      1. See more in 3085993 - Troubleshooting guide for the SAP Analytics Cloud, add-in for Microsoft Office
  2. Mac:
    1. 3625313 - How to enable development tools in SAC add-in for Excel Desktop on Mac
    2. Microsoft documentation "Debug Office Add-ins on a Mac"
10. Check Memory Consumption
  1. task manager
  2. browser: development tool
  3. WebView2
  4. Understanding the Office Add-ins runtime
Future Release Plan
1. 2937385 - Release Plan for SAP Analytics Cloud, add-in for Microsoft Excel
Future Planned Functions:
1. Road Map: SAP Analytics Cloud, add-in for Microsoft Office
Submit Enhancement Request
1. Influence Page for SAC: https://influence.sap.com/sap/ino/#/campaign/884
Submit a SAC related support case in SAP
1. Before Submit:
  1. Microsoft 365 version and status:
    1. Test with latest add-ins version: Insert - Office Add-ins and insert the latest version of the add-in.
    2. Test with latest browser version
  2. Check if the issue is reproducible in local network/firewall/VPN/Azure Server..etc
  3. Check if the issue is related to local machine(test with other machine)
  4. Check if the issue is related to certain browser(Chrome, Edge, Safari)
  5. Check if the issue is related to certain user (test with admin or planning admin)
  6. Check if the same function is reproducible in SAC tenant
2. Affected SAC tenant URL and Enable support user feature:
  1. Go to System > Administration > System Configuration page.
  2. Click the pencil (edit) icon.
  3. Search for “SAP Support”
  4. Enable the option to "Allow SAP Support User Creation".
3. Affected workbook menu path/URL
4. Affected data source info(live connection: BW/S4HANA/DataSphere...etc, source system information)
5. Steps to reproduce the issue
Submit a Microsoft related support case in Microsoft
1. Get support for Microsoft 365 for business

Keywords

SAC Add-in, Login Blank Page, SAC, excel, login, URL, SAP Analytics Cloud, add-in for Microsoft Excel, SAP Analytics Cloud, add-in for Excel, https://hcs.cloud.sap https://*.live.com https://*.online.office.de https://*.sharepoint.com System Administration App Integration Trusted Origins blank, logon, login, desktop, not working, window, browser, ie, vpn memory limit Edge, Chrome or Safari memory consumption SAP Analytics Cloud, add-in, clear cache, Mac, Microsoft Excel ProductId 8a512e2b-c04e-4c06-9235-11b6cd59f584 OrganizationAddInOverrides AddInOverridesCreationException domain on *.officeapps.live.com AppDomains _OSF_PRIVATECATALOG_ADDINS ADMIN MANAGED MY ADD-INS landing Page Version landingPage office&landingPageVersion=1&addinVersion=1.21.0.0&addinName=ms-store&latestAddinVersion=1.21 SAP.GETDATACOMMENT Monthly Enterprise Channel Semi-Annual Enterprise Channel Publish Data, Revert Data, SAC, Excel, Add-In, table, workbook, Planning Enabled, turned on, turned off, enable, disable, parameter, option , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-OF , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0