cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Data Blending issue

04-23-2026 6:51 PM
Jennychndr61_ Newcomer
365 views 0 comments
0 Likes
SAP Managed Tags
Subscribe

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

0 Likes

Accepted Solutions (0)

Answers (0)