Blending Data in Models

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Use blending for creating stories with data from multiple models and datasets

Add New Data

You can create a story with visualizations using data from multiple models and datasets. For example, one page could contain visualizations on data from a Sales model, and another page, visualizations on data from a Customer model. Or, visualizations on data from both models can be placed on a single page.

Blend Data

Blending enables you to join a primary data source with secondary data sources that contain common linked dimensions in a single story. 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 dataset that has been added to the story. Blending can be done within individual tables and charts.

The figure Blending Result illustrates the blending of data from two table.

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

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.

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 create links between dimensions to define the common data in multiple models. You can then use the 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 levels.

Note

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

Blending Data in Stories

Task 1: Use blending data in stories

Business example

You have similar data from multiple data sources, so you need to blend the data together into a single table or chart. After the data is blended, you can then perform linked analysis on widgets that have different data sources.

Task flow

In this simulation, you will perform the following tasks:

  • Add a link for an employee position
  • Add a tool tip for the dimension
  • Use the blended data to view the story

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

Login or Register