Run Survey Response CSV report using different filters, the Question column (column U) will be in ascending, descending or random sort.
SAP SuccessFactors Learning
Reproducing the Issue
- Login System > Learning Administration
- Go to Reports > Survey Response (CSV)
- Filter User ID or Survey ID or State Date&End Date >Export report.
- See the Question column (column Q) is sorted differently.
This is a known feature limitation. HANA DB cannot guarantee the sorting order unless the ORDER BY query is at the end.
The enhancement requires a framework level effort. Since Birt report (LMS report) is going to be sunset, there is no plan to enhance this feature.
Customer can sort manually on exported Excel file, or start using SAC (Stories) reporting, which the sequence is guaranteed.
Question order, Item evaluation report , KBA , LOD-SF-LMS-REP , Reporting Data , Product Enhancement