SAP Knowledge Base Article - Public

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


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.


SAP Analysis for Microsoft Office


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


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.


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


SAP Analysis for Microsoft Office all versions