SAP Knowledge Base Article - Public

2435721 - Analysis for Office Performance troubleshooting guide

Symptom

You are using Analysis for Office tool running BW queries or views and want to improve the performance of the execution.

Environment

SAP Analysis for Microsoft Office

Resolution

For any performance issue related to Analysis for Office running BW queries or view, follow the steps below:

  1. SAP recommend to use the latest patch that contains performance corrections. It is recommended to check the item 4 of the Analysis Office Installation and Update wiki page.
  2. Check SAP note 1703279 - General performance recommendations Analysis Office
  3. Apply SAP note  2245034 (On this note you have a PDF with all function modules that requires a specific BasXML configuration to improve the performance)
  4. Check Analysis for Office performance wiki page.

Keywords

performance,optimizing,recommendation,statistics,profiling,rsrt,rstt,bics,rsddstat_olap,frontend,analysis,office, AO, BW , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , How To

Product

SAP Analysis for Microsoft Office all versions