SAP Knowledge Base Article - Public

3571851 - Error when opening BW Queries with EPM Add-in

Symptom

Error opening Queries in EPM from BW system.

No cells were found.#

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)

|FPMXLClient.Forms.ReportManager.ReportManagerDialog.ButtonOk_Click|str213|||||VSTA_Main|Object reference not set to an instance of an object.#
System.NullReferenceException: Object reference not set to an instance of an object.

Environment

Excel 365 Semi annual channel

Reproducing the Issue

  1. Open Excel and access to “EPM->Log on” and select the connection BW system 
  2. find the Queries, Select a Query to open in the Report Editor,
  3. add any dimension to the report and click OK(Drag from dimension panel down to dimension )
  4. Finally, it displays the following error: "object reference not set to an instance of an object"

Resolution

EPM add-in SP38 Patch18.
Also, part of Analysis for Office 2.8 SP25

Keywords

KBA , EPM-XLS , EPM Excel Client , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.8