Blending Data

You can create stories with visualizations using data from multiple models and datasets.

Blending models lets you join a primary data source with secondary data sources that contain common linked dimensions. For example, you can blend data from a corporate data source with data from a local spreadsheet, or blend data from a public model with data from a private model derived from a dataset's integration into a story. Blending can be done within individual tables and charts.

For details, see Creating Linked Dimensions.

Note
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.
Note
Geo maps are not supported with linked models.
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.
Getting started on blending with data

You can blend data between models that are based on imported data stored in SAP Analytics Cloud, without needing 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. For more information, see: