SAP Knowledge Base Article - Public

2600093 - No Data Available in When Running a Report in Another Language - Advanced Reporting

Symptom

  • No Data available running the report in a different language
  • The report works properly in the language it was created
  • You have shared the report with an user and when you do proxy as him the report works. However, if you run the report logged in as this user the report is blank
  • A report runs fine in an Online Preview, but return a blank output or no data for CSV/XLS/XLSX formats
  • Some users can’t export Report - Canvas in xls/xlsx/csv but others user can. Word/PDF/PPT works

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Reproducing the Issue

1. Proxy as the affected user and run the shared report Online
2. Notice that Online Preview may work and show data
3. Now Export the report or Run it Offline as CSV/XLS/XLSX
4. Download the file.  Notice that the output contains no data.

Cause

There is a static filter on a label field type (text string against a language-sensitive label). When we change the language in BizX, the filter no longer matches, so this is expected behaviour. In the example below the filter was applied in English. After changing the language to French, some values may not match:

label.jpg   label french.jpg

Resolution

The correct approach is to filter on the "code value" of that field (e.g. Employment Type - Internal or External Code). This does not change when we switch the language. It also protects against someone slightly changing the wording of a label entry, which would also break the filter.

codes.jpg    code french.jpg

Keywords

No Data available running the report in French language english share with user proxy logged in blank Advanced Reporting change BizX filter label code, excel export blank, word pdf ppt works , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Product Enhancement

Product

SAP SuccessFactors Workforce Analytics all versions