Symptom
Data Blending returns less data than expected in SAP Analytics Cloud (SAC)
Environment
SAP Analytics Cloud 2025.1
Reproducing the Issue
- Log on to SAP Analytics Cloud
- Create a story and make the data source to have at least 1 Live BW model and 1 import data model. And create Data blending to link the two tables.
- Make the Live BW model as the primary one. Set the link type as All primary data, Unlinked dimensions options as Merged Members.
- Find after blending, the data returned is less even compare the data only comes from the primary Live BW model.
Cause
- The data which is sent for the primary model is limited to 500 rows and 60 columns.
- This is happening when the drill limit was set after the blending is performed. In this case, the drill limitation will only take effects for the blended query but not the original primary query.
Resolution
- Before setting up the data blending, after the 1st model with data is placed in the table, edit the drill down limitation to unlimited in table first. After that, setup blending with the 2nd model.
- Doing the above can help to change the primary query drill limit also to unlimited, which can prevent the truncated data behavior.
See Also
Keywords
SAP Analytics Cloud, SAC, data blending, less data, live BW model, import data model, dimension, filter, channel code, single model data source, HTTP-based tool connection, Apache, support-qrc tenant, blended, date range. , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0