SAP Knowledge Base Article - Public

2518388 - Performance issue in Analysis Office

Symptom

There is a performance issue in Analysis for Office tool.

Environment

SAP Analysis for Microsoft Office

Resolution

  • If there is a performance issue in Analysis for Office tool, check first whether the issue is reproducible in the latest version of Analysis for Office. Generally there are performance improvements in each AO patch. Important improvements are documented in SAP Notes, but not all minor improvements. Visit the Support Content page Analysis Office Installation and Update and follow the instructions in section #2 to download the latest version of Analysis for Office. Then install it in just one test machine and check whether the issue is reproducible. Check topic #4 about the importance of checking the issue in the latest version of the tool.

  • In case the performance issue remains, attach to the SAP case the following traces:
    1. Support level AO traces recorded in the latest version by following the instructions of SAP Note 2129389.
    2. Profiling traces recorded in the latest version by following the instructions in https://help.sap.com/docs/SUPPORT_CONTENT/sapao/3361383447.html?locale=en-US
    3. HTTP traces recorded in the latest version by following the instructions of SAP Note 3237524
  • If HANA scenario, also check KBA 2470059.

  • More information about how to analyze performance issue in AO can be found in Support Content page Performance in AO

See Also

KBA 2435721 - Analysis for Office Performance troubleshooting guide

Keywords

performance, slow, slower, fast, faster, time, minutes, several, run, open, display, data, improve , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem

Product

SAP Analysis for Microsoft Office all versions