SAP Knowledge Base Article - Public

2825634 - Pivot/Chart does not display all labels / categories

Symptom

Pivot Query / Chart reports do not display all labels / categories, in the column header/x-axis, respectively.

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 HCM Suite

Reproducing the Issue

  1. Run a Pivot/Chart report as User A
    1.  You will see data with different column labels (in pivot) and category labels (in x-axis of the chart)
      AanyaSingh.jpg



  2. Now, run the same report as User B
    1. You will NOT see all the column labels (in pivot) and category labels (in x-axis of the chart)
      LorenBond.PNG

Cause

Based on the data, which a particular user is having access to, the categories/labels will differ.

In the above scenario, User B does not have access to records/data with values 'Outstanding', 'Too New To Rate' or 'Unsatisfactory'.
Hence, they are not seen in the Pivot Columns as well as chart's x-axis (which is built using the same query as the pivot).

Resolution

Working as intended: It is NOT possible to display cateories/labels with default value (such as 0 or '-') in Pivot / Chart reports.

Keywords

pivot, chart, category, label, categories, labels, possible, default, value, values, ORD, component, table, canvas, report, reports, display, x, axis, header, column , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM suite all versions