3788815 - Story offline schedule exports all data source columns and changes date format in csv (people analytics story reports)

• When scheduling a story and selecting only one table widget, the generated CSV contains all data source columns instead of only the columns configured in the selected table widget.
• In the scheduled CSV, date columns are formatted as mmm d, yyyy (for example, "Jul 1, 2000") even when the language/locale is Japanese; the expected format is yyyy/MM/dd (for example, "2000/04/01").
• Exporting the same table widget directly from the story page to CSV (scope: all) outputs only the selected columns and keeps the date format as yyyy/MM/dd.

• SAP SuccessFactors Platform
• Embedded usage of SAP Analytics Cloud

1. Set the application language to Japanese and open a story that includes a table widget with date columns.
2. From the story page, export that table widget to CSV with scope set to All.
3. Confirm the CSV contains only the table’s columns and that dates are in yyyy/MM/dd.
4. Create an offline schedule for the same story.
5. In the scheduler, select the specific table widget (not the data source), choose CSV output, and start the schedule.
6. After the job completes, download the scheduled CSV.
7. Observe that all data source columns are exported and date columns are formatted as mmm d, yyyy.

There are two issues identified in above workflow:

1. The schedule job result contains all columns of the query
2. The date format is not as expected as user's language setting.

• For the 1st issue about all columns in CSV of this workflow, this is identified as product defect and planned to be fixed in further product release.
• For the 2nd issue about the date format in csv, this behavior is BY DESIGN. This is because the data export functionality is designed to retrieve data from the backend database (HANA) and persist it into a defined flat file format (e.g., XLSX, CSV). The date format observed in the exported file is a result of this standard export behavior. 

story, schedule, offline schedule, csv, table widget, export, date format, yyyy/mm/dd, mmm d yyyy, japanese locale, data source columns, report center, people analytics, sac embedded, story reports , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem