SAP Knowledge Base Article - Public

3426056 - Parallel and sequential processing of queries in Analysis for Office workbooks

Symptom

An Analysis for Office workbook with multiple queries is taking longer to load compared to a workbook with only one query.

Environment

  • SAP Analysis for Office

Reproducing the Issue

  1. Open AO
  2. Insert Data Source
  3. Select Data Source for Analysis
  4. Logon to backend system
  5. Select a query
  6. Insert the same query multiple times on the same workbook (repeat the steps above)
  7. Click on Refresh All
  8. Confirm it takes longer to load, even though the individual refresh of this query is faster

Cause

Product limitation. It is technically not possible to execute queries in parallel in Analysis for Office.

Resolution

AO can only execute queries sequentially and not in parallel.

See Also

Hints on how to use VBA to improve the initial load performance in AO workbooks: SAP Note 1962934.

Keywords

KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions