SAP Knowledge Base Article - Public

2435721 - Analysis for Office Performance troubleshooting guide


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


SAP Analysis for Microsoft Office


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.


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


SAP Analysis for Microsoft Office all versions