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.
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:
No comments:
Post a Comment