Linking and Blending Data in Stories

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Use linked analysis for setting filters on different story components
  • Use blending for creating stories with data from multiple models and datasets

Linked Analysis

Linked Analysis allows you to set filters on different components of one story. This requires that all components involved are based on the same data model, or that the filter was created on a linked dimension.

Watch this video to learn about the linked analysis options.

Most components can be used as a filter input, with selectable options such as columns and fields. Selected values can be used as filter values for other components.


Linked Analysis is available when working on multiple widgets and a single model. Linked analysis can also be used for widgets from different models as long as the models are blended.


You can create stories with visualizations using data from multiple models and datasets. Blending enables you to 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.

The figure below illustrates the blending of data from two table.

After blending, you can create calculations that use measures from multiple datasources.

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.

Some common uses for blending are as follows:

  • 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 third party consulting firm.

  • Creating custom calculations based on key performance indicators from different data models, such as 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.

Linked Dimensions

You can create links between dimensions in multiple models. You can use linked dimensions to create blended charts or tables that display data from multiple models. Linked dimensions also allow you to create filters that simultaneously update all charts that include linked data. Filters on linked dimensions can be used at the story, page, and linked analysis level.


When creating linked dimensions for SAP BW data sources, you can choose to link on matching hierarchies.

Use Linked Analysis & Blending

You need to know how to use linked analysis to filter data for multiple visualizations at one time. You have similar data from multiple data sources, so you need to blend the data together into a single table or chart. Lastly, you want to be able to filter data using linked analysis for charts that use different data sources.

Task Flow

In this exercise, you will perform the following tasks:

  • Use Linked Analysis to filter data for multiple charts that all use the same data source.
  • View existing linked dimensions between the Shipping and Finance model.

  • Set up and use Linked Analysis for Shipping and Finance models.

  • Use the Linked Analysis data point selections.

  • Add a new linked dimension for employee data and add HR Position as a tool tip.

Save progress to your learning plan by logging in or creating an account