SAP Knowledge Base Article - Public

2354859 - Is it possible set a column header for a Pivot Query / Table Component?

Symptom

No row headers or labels are displayed for the Pivot table / query component in Online Report Designer or Report - Canvas.

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

Environment

  • SAP SuccessFactors HXM Suite
  • Report Canvas
  • Advanced Report

Reproducing the Issue

  1. In Analytics ORD/Canvas, create a new report page and add a pivot table component.
  2. Note that the columns have no headers or labels.

 

Pivot Table no Headers.jpg

Resolution

Working as Designed.

This is an enhancement request,  Please see the following posts at the SAP SuccessFactors Community.

The first link has an explanation from Product Management regarding this function and a possible workaround for the headers (use of text tokens).

Note: It is not possible to export the text token in Excel. As workaround you can export the Canvas report in PDF format.

Row Headers in ORD created Pivot Table

Pivot Query Columns

tokens.png

Please also see the following links for the SAP Influence site and vote for the Improvement requests:

Online Report Designer - Show Column headers in pivot table

Row Headers in ORD created Pivot Table

Keywords

Pivot, table, query, row, headers, column, headings, field, labels, ORD, report, component, Canvas, center, Online, Designer , KBA , missing header , report missing header , LOD-SF-ANA-ORD , Online Report Designer , Product Enhancement

Product

SAP SuccessFactors HXM Suite all versions