SAP Knowledge Base Article - Public

3204315 - Converting multiple rows of data into a single row in advance reporting is not working

Symptom

There is one scenario where we can't convert Multiple row data into Single row in advance reporting.

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
    • Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
      • Advanced Reporting (ODS)

Reproducing the Issue

  1. Login into instance.
  2. Create a Advanced report as mentioned in resolution section of KBA (2545465 - How to convert multiple row data in single row in Advanced Reporting (transpose))
  3. When there is a association table between Driving table and related table, like below

       

        4. The output might not be in a single row

     

Resolution

It is a limitation in the system. 

Whenever there is an associated table between Driving table and the table on which we have to apply Transpose, output doesn't show up in a single row.

Keywords

Limitation, Transpose, Multiple, Single, Row, Advance, Reporting, Convert , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HXM Suite 2205