SAP Knowledge Base Article - Public

3126086 - Question column is sorted randomly on Survey Response CSV report

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

  1. Login System > Learning Administration
  2. Go to Reports > Survey Response (CSV)
  3. Filter User ID or Survey ID or State Date&End Date  >Export report.
  4. 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

3055705 - Learning Data Available for Stories in People Analytics

Keywords

Question order, Item evaluation report , KBA , LOD-SF-LMS-REP , Reporting Data , Product Enhancement

Product

SAP SuccessFactors Learning all versions