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

When using a version higher than AO 2.8 SP12, a new option "Repeat Titles" is available as shown below:

Repeat Titles.png

In order to repeat titles in columns, use a version higher than Analysis Office 2.8 SP12 and select the option "Repeat Titles". Refer to SAP Note 1518359 to download the latest version of Analysis Office.

More information in chapters What's New in Analysis 2.8 SP12 and The Components tab.

Keywords

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

Product

SAP Analysis for Microsoft Office all versions