Symptom
Run Survey Response CSV report using different filters, the Question column (column U) will be in ascending, descending or random sort.
Environment
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.
Cause
This is a known feature limitation. HANA DB cannot guarantee the sorting order unless the ORDER BY query is at the end.
Resolution
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.
See Also
Keywords
Question order, Item evaluation report , KBA , LOD-SF-LMS-REP , Reporting Data , Product Enhancement