SAP Knowledge Base Article - Public

2519385 - Report dates change when export to excel

Symptom

When building a query in Detailed Reporting in the Online Report Designer, preview data can get a pre selection of filters in a mandatory date filters.

In preview data is displayed as of a specific date picked in mandatory date filters, but on export it is displayed as of "today" instead of the selected date.

 

 

Cause

Offline export function does not honor the mandatory date filters and hence export files shows different number of records as compare to records present in UI. This is primarily happening for EC data in Detailed Reporting.

Resolution

Building the query/ Report in Advanced Reporting is preventing this from happening as preview and offline export adhere to the date filter selected.

Keywords

Online Report Designer, Mandatory filter prompt, preview different from export , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core 1702 ; SAP SuccessFactors Workforce Analytics all versions