Blogs / SAP / SAP Analytics Cloud / Blending Datasets in SAP Analytics Cloud

Blending Datasets in SAP Analytics Cloud

Apr 9, 2019

SHARE

There are two ways to combine data sources in SAP Analytics Cloud. One is by combining data sources at the model level at the time of model creation – the details of which can be seen in this blogThe other is by blending datasets in SAP Analytics Cloud, which we will look at in detail here.

SAP Analytics Cloud offers this key capability to blend multiple data sources into the same chart or table by linking or joining common dimensions between them. Any filters passed or selections made are reflected in all the linked components in the page. Also, for blended datasets, the consolidated list of dimensions and measures from the two models are displayed in the Designer.

SAP Analytics Cloud now supports data blending between live data models and data models based on imported data stored in the SAC.

Blending between these different sources is supported – as seen in the image below:

Blending Datasets in SAP Analytics Cloud

For this blog, as an example, let us see how blending works between Live and Acquired data models.

Data Sources used:

  1. Live Connection – HANA
  2. Acquired data – BW

Create a new story by consuming these datasets in two different charts as shown below:

Blending Datasets in SAP Analytics Cloud

Linking Dimensions

Here are the steps to link dimensions:

1. Click on the ‘Link Dimensions’ option in the ‘More’ menu. Alternatively, you can find this option in the Data Source area of the Builder panel when you are creating or editing a chart.

Blending Datasets in SAP Analytics Cloud

The ‘Link Dimensions’ dialog box appears.

Blending Datasets in SAP Analytics Cloud

2. In this dialog box, you must link the primary model on the left to the secondary model on the right. Expand the drop-down list in the left pane and click on the ‘Add model’ option. In the ‘Select a model’ dialogue box, select the model ‘HBS_TEST’, and click on ‘Set’ to close the dialog box.

Blending Datasets in SAP Analytics Cloud

After linking, the dimensions and measures from both models (linked) will appear on the right of the panel.

Blending Datasets in SAP Analytics Cloud

Note: The Links that are created between data sources are available only in the stories and do not impact the underlying models.

There are a few options available to configure the ‘Link Type’. You can also define which dimensions are to be unlinked.

3. As shown below, there are three types of Linking based on data.

Blending Datasets in SAP Analytics Cloud

‘All primary data’ – Includes all data in the primary model, and only the corresponding matching data in the secondary model (similar to left outer join)

‘All data’ – Includes all data in the primary and secondary models (similar to full outer join)

‘Intersecting data only’ – Includes only matching data (similar to inner join)

Summary

The matrix below summarizes data blending possibilities between various types of models based on live data, acquired data, flat files, and non-SAP data.

Blending Datasets in SAP Analytics Cloud
Updated for version Q3 2020

Reach out to us here today if you are interested to evaluate if SAP Analytics Cloud is right for you.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!