Technical Articles
Blending Models with SAP Analytics Cloud
What is Blending?
Blending models lets you join a primary data source (such as ‘travel expenses’) with secondary data sources (such as ‘employee headcount’) that contain common linked dimensions (such as ’employee’). A new model is not created when you blend models, and the original models are not modified. Links between models that are blended only occur within a story. Blending can be done within individual tables and charts.
Some common uses for blending
- Comparing data of actuals from a corporate SAP source with plans stored from a non-SAP source.
- Comparing sales results against market benchmarks, or marketing campaign results available in .csv files, or data provided by a 3rd party consulting firm.
- Creating custom calculations based on key performance indicators from different data models like public census data.
- Using Smart Predict to output predictions in a dataset, and blend these predictions with other data sources, in the context of a story.
Technologies used for blending
There are 3 technologies used for blending:
- Native blending:
This means the blending occurs within SAP Analytics Cloud ‘natively’. No additional technology is needed.
- Browser based blending:
This means the data is transmitted, via the users’ web browser, and temporarily stored in either the Primary or Secondary data source where the blending itself occurs. Although no special setup is required it is highlighted as additional requirements or restrictions apply. Please refer SAP Note 2715871.
Typically recommend browser-based data blending to business users or data analysts who want to blend smaller aggregated datasets together within a story. A system-defined data volume limit ensures that the data blend operation within the story performs as expected. In general, we recommend trying browser-based data blending with live models first, because this approach should meet most business users’ needs.
When users are linking dimensions for the purpose of browser-based blending, a warning is shown if the data volume limit is exceeded:
An error message is shown if the blending operation doesn’t complete successfully due to the data volume limit being exceeded:
Note:
- SDI based blending:
This means the data is transmitted, via Smart Data Integration (SDI), and temporarily stored in either the Primary or Secondary data source where the blending itself occurs. SDI need to be setup between the data source and SAP Analytics Cloud. This means an SDI Agent to be running and connected to the HANA system via SAP Cloud Connector.
SDI is recommended over browser based blending.
Matrix to show which models can be blended to other models based upon the connection underlying the SAC model
Note:
- Data blending with imported data stored in SAP Analytics Cloud don’t require any blending-specific prerequisites or setup.
- Data blending with models based on live data is also supported for specific SAP data sources, but does require additional prerequisites and setup.
Hi Naveen,
Thanks for this blog.
Just to correct one point:
According to SAP, Browser based blending is the recommended option.
Best,
Luiz
Thanks Naveen for the excellent blog, I have below questions
1. Are these mentioned blending options possible with the Planning model?
2. Are there any blending option to blend both Planning model (Import connection to BW4HANA) and Analytic model (Live Connection to BW4HANA) in SAC?
Best Regards,
Karthi
Hi karthik pitchai ,
Did you able to get answer for this?
Can we blend BW live model with Planning model?
Please let me know if you get any answer for this?
Thanks,
Saif Khan
Hi Naveen
Is it possible to trace in which stories data blending is used ?
Thanks
Andreas
Hi Naveen,
Thanks for the info. Can you please let me know how we can exclude using linking of the 2 models to show data present in only 1st model? Basically, I have a requirement to show only the Credited Transactions that are not used in any of the Measurements. My first model in the story would be 'Credited Transactions' and 2nd model would be 'Measurements'. I need to build a Orphaned Credits Report. Please let me know how this can be accomplished in SAP Analytics Cloud or Embedded Analytics in HANA?