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)
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
Reproducing the Issue
- Login into instance.
- 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))
- 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