Symptom
When a user runs a report and see data in preview all the calculated column labels shows correctly, and when this report is exported offline will see different/duplicated calculated column labels.
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
- Under reporting --> Run a canvas report
- In online can see all the calculated column labels are showing correctly
- Export the report offline and can see Labels are different
Cause
This happens when we apply different label for a calculated column in Multiple locales.
Suppose if Bizx locale is in EN_UK and in calculated column if we set one Label ("X") in EN_US and different label ("X1") in EN_UK.
and when user "A" runs the report for whom the locale present in user maintenance is "EN_US"
In online Preview the output will be shown same as Bizx locale and we can see Label "X1" but the same report when exported offline we see Label "X"
Offline export uses the language from WFA user maintenance.
Resolution
Whenever we see different calculated column label in offline export then compared with online preview.
First we need to edit the report and check if the calculated column has different names defined in different locale's and
In user maintenance we need to check the locale of the user running the report.
The calculated column label in output file matches with Locale set for user in user maintenance.
Keywords
Calculated, Column, Different, Label, Locale, User, Maintenance, Canvas, report, offline, online, Preview, export, WFA , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem