SAP Knowledge Base Article - Public

2997321 - Column header is missing when a dimension is set to display both key and text

Symptom

When a dimension/characteristic is set to display both Key and Text (or Text and Key, the order is not relevant), the header is missing in the second colum, as shown in the screenshot below:

Blank column.png

The "Repeat Members" option does not change the behavior.

Environment

SAP Analysis for Microsoft Office

Cause

This is the normal behavior when using a version lower than AO 2.8 SP12.

Resolution

In order to repeat members in columns and rows, use Analysis Office 2.8 SP12 or higher version. Refer to SAP Note 1518359 to download a different version of Analysis Office.

Keywords

blank cell, repeat member, missing, display, empty , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions