Hello SAP Community,
I am experiencing a data duplication issue when exporting
a blended data model from SAC Stories to Excel/CSV.
ENVIRONMENT:
- SAP Analytics Cloud (Stories)
- Live SuccessFactors EC connection
- Data Blending between 2 models
- Both models are flat compensation portlets
ISSUE:
When exporting blended table via widget Export,
rows are duplicated in multiples of 20 (x20, x40, etc)
PATTERN OBSERVED:
- Under 10,000 rows → export is clean, no duplication
- Over 20,000 rows → duplication starts, always x20 pattern
- SAC table/story displays correctly, issue only on export
- Duplication happens with composite key blend only
- Personnel Number only blend works fine at 80,000+ rows
COMPOSITE KEY FORMULA:
PersonnelNumber + PayComponentID +
YEAR + zero-padded MONTH + zero-padded DAY + Sequence
WHAT I HAVE TRIED:
- Added zero padding to month and day in key formula
- Verified no duplicates exist in source models individually
- Verified key uniqueness in both models
- Tested with simple flat portlets (no self-join) - same issue
- Widget export and general export both produce duplicates
CONCLUSION:
Issue is reproducible and consistent. Appears to be SAC
export pagination bug specific to composite key blending
on large datasets with live SuccessFactors connection.
Has anyone experienced this? Is there a known workaround
or SAP note addressing this?
Thank you
Request clarification before answering.
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.