SAP Knowledge Base Article - Preview

3292589 - Troubleshooting guide for DWC issues in SAP Analysis for Microsoft Office

Symptom

Since Analysis Office version 2.8 SP14, it is possible to connect to Data Warehouse Cloud (DWC) from Analysis Office and analyze DWC datasets.

This document provides some guidance on how to troubleshoot DWC issues when using the SAP Analysis for Microsoft Office and how to find the correct SAP product area (component) to report product issues (if necessary).

  1. Refer to chapters below in the Administrator and User guides to make sure that everything is in place:
  2. Refer to chapter Restrictions when working with SAP Data Warehouse Cloud datasets to check the functions not supported;

  3. If the issue is related to connection or logon to DWC system, make sure that the user is able to connect and logon to DWC system in browser just fine.
    • If not: create an incident by selecting component DWC-SM (attach a Fiddler trace to the case as described in SAP KBA 2385888).
    • If yes: create an incident by selecting component BI-RA-AO-XLA (check section #6 in this document).

  4. If the issue is related to performance or error message when consuming a DWC dataset, check if the issue is reproducible when previewing the data in DWC in browser:
    1. Connect to DWC system in browser;
    2. Click on "Repository Explorer" in the menu;
    3. Search for the DWC dataset and open it by clicking on its name;
    4. Click on the "Data Viewer" button and then "View Data";
    5. Check if the issue occurs.

      Is the issue reproducible when previewing the data in DWC in browser?
    • If yes: create an incident by selecting component DWC-MD-VIW (attach a Fiddler trace to the case as described in SAP KBA 2385888).
    • If no: create an incident by selecting component BI-RA-AO-XLA (check section #6 in this document).

  5. If the issue is related to unexpected behavior/data, performance or error message when consuming a DWC dataset, check if the issue is reproducible when creating a Story in SAC in browser:
    1. Log into the SAC web client with a supported browser (Client Software Requirements);
    2. From the Main Menu, select "Stories";
    3. Create a new Canvas story;
    4. Add a Table object (widget);
    5. Select "SAP Data Warehouse Cloud Analytical Dataset";
    6. Select the connection to DWC, the Space and the Dataset;
    7. Follow the same navigational steps that are followed using the Analysis Office to reproduce the issue.

      Is the issue reproducible when creating a Story directly in SAC using the DWC dataset?
    • If yes: create an incident by selecting component LOD-ANA-DES.
    • If no: create an incident by selecting component BI-RA-AO-XLA (check section #6 in this document).

  6. Information required when opening an incident with SAP

    After determining from steps above that the issue is related to the SAP Analysis for Microsoft Office or when creating an incident by selecting component BI-RA-AO-XLA, please provide the following information:

    1. Is the issue reproducible in the latest version of Analysis for Office? To download it, visit this link and follow the instructions in section #2.
    2. Attach to the incident the Analysis Office trace (recorded in the latest version) as described in SAP Note 2129389;
    3. Attach to the incident the HTTP trace as described in SAP KBA 3237524;
    4. Attach to the incident a document with complete step-by-step to reproduce the issue;
    5. Follow the steps in SAP KBA 3200458 to make sure that SAP can create a support user for reproduction purposes;
    6. Provide the DWC tenant URL and make sure to select the correct DWC system when creating the incident.


Read more...

Environment

SAP Analysis for Microsoft Office

Product

SAP Analysis for Microsoft Office all versions

Keywords

data, warehouse, cloud, dwc, view, crash, exception, performance, connection, logon, login, tenant , KBA , BI-RA-AO-XLA , Excel Addin , 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.