Symptom
When creating pivot tables on Canvas reporting the data is not being exported with data on all lines. The cells are being merged.
Environment
SAP SuccessFactors People Analytics
Resolution
This is an expected behavior and the cells will be exported merged in the Canvas Pivot Tables. It is not possible to change this.
If you considering having this function is a great fit to your business requirements, we strongly suggest opening an enhancement request as per described on KBA 2090228 - How to submit enhancement ideas for SAP SuccessFactors Products.
See Also
KBA 2493771 - How to Create Pivot Tables in Online Report Designer (ORD)
KBA 2354859 - Pivot query / table component has no row headers in ORD
KBA 2090228 - How to submit enhancement ideas for SAP SuccessFactors Products
Keywords
Pivot table, ORD - Merged cell - Export Pivot table, canvas, merge, advanced reporting, deltailed reporting, merging, export, Canvas Reporting, Published Data, ADV , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem
SAP Knowledge Base Article - Public