Stories can run successfully, show an empty blended table


Your SAP SuccessFactors Story can run successfully, show an empty blended table, and still have non-zero data outside the result.

That is not a hypothetical edge case.

SAP documents it.

Since August 17, 2026, blended tables have been available in production in the Optimized Story Experience.

But there are two things I would test before trusting the output.

First, the table must use the New Table Build Experience.

Linked models need to be added to the table context, with at least one linked dimension from the primary model.

And I would test the conversion on a copy first.

SAP KBA 3766949 explains that the new table behaves similarly to a chart. If the model contains both accounts and measures, at least one account and one measure are required for data to display.

Second, watch the data volume and drill limit.

Primary model: default 500 rows × 60 columns

Linked model: unlimited drill limitation

If the primary-model query returns truncated data, blending can produce inaccurate results.

The example is striking.

If the truncated 500 rows contain only zero values, zero suppression can produce an empty table even though non-zero values exist outside that truncated result.

My validation sequence:

• Test the conversion on a copy

• Check primary-model record volume

• Check drill limitations

• Test zero suppression

• Validate exported results

• Compare blended totals with source-model totals

A successful report execution is not proof of data accuracy.

No comments:

Post a Comment