SAP Knowledge Base Article - Public

3603884 - SAC Optimized Story some records are duplicated when exporting as .xlsx and scope "all"

Symptom

  • Some records are duplicated when exporting table in ODE story, using .xlsx file type and scope All.
  • When opening the excel file, there are some duplicated records, however in SAC there are no duplicates.
  • Other formats like .csv with scope All works fine when exporting.

Environment

SAP Analytics Cloud 2025.1.16

Reproducing the Issue

  1. Open ODE story in SAC that has table filled with data.
  2. Select a cell in the table to make the three dots (...) visible in the top right corner of the table.
  3. Click on the three dots (...) -> Export
  4. Select .xlsx for the file type and all for the scope.
  5. Press OK and wait for table to export.
  6. Open the .xlsx and find the duplicated records using filters/sorting etc.
  7. Observe in SAC story that the duplicated record shows up only once, however in the excel file it is duplicated.

Cause

Under investigation by development team.

Resolution

N/a

Keywords

Excel, export, xlsx, scope, all, SAC, duplicates, duplications, double , KBA , LOD-ANA-UNS-EXP , Unified Story PDF/PPT/Excel/CSV Export , Problem

Product

SAP Analytics Cloud 1.0