SAP Knowledge Base Article - Preview

2434803 - Merge Variables in Analysis for Office workbook shows empty data cells

Symptom

Open an Analysis for Office workbook at the first time the report runs correctly, but when selecting new variable values in the prompt screen, then the data in the cells disappear and show empty data cells. Then after changing the prompt values again in the report, then the data will be available again.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • Advanced Analysis Office
  • SAP Business Objects Analysis, edition for Microsoft Office 2.x

Product

SAP BusinessObjects Analysis 2.0, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.1, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.3, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office ; SAP BusinessObjects Analysis for Microsoft Office 2.5 ; SAP S/4HANA 1610

Keywords

Merge Variables, Analysis for Office, workbook, shows empty data cells, dissapear, HANA. , KBA , BI-RA-AO-XLA , Excel Addin , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.