3.8 Linking and Blending Data in Stories

Question 1

What are the two requirements for a linked analysis

Answer 1

1. all components involved are based on the same data model
   OR
2. filter is created on a linked dimension

Question 2

What is blending

Answer 2

• join a primary data source with secondary data source that contain common linked dimensions.
• can be done with individual tables or charts

Question 3

Where does the blending of two models/datasets occur

Answer 3

it only occurs within a story, original models are not modified and a new model is not created

Question 4

Common uses for blending (4)

Answer 4

• compare SAP actuals with non-SAP plan data
• compare sales against external data source
• create custom calcs based on KPI from diff models
• using Smart Predict to output predictions in a dataset, and blending predictions with other datasources/into a story

Question 5

What levels can linked dimensions be used (3)

Answer 5

• story
• page
• linked analysis

Question 6

Link types (3) and what they return.

Answer 6

1. Primary data
2. Intersecting data only
3. All data

Question 7

In this example, what would a Linked Dim - Primary data return?

Model1 Model2
Red Red
Blue Green

Answer 7

Red, blue

Question 8

In this example, what would a Linked Dim - Intersecting data return?

Model1 Model2
Red Red
Blue Green

Answer 8

Red only

Question 9

In this example, what would a Linked Dim - All data return?

Model1 Model2
Red Red
Blue Green

Answer 9

Red, Blue, Green

Question 10

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

Answer 10

True

Question 11

When is linked analysis available (2)

Answer 11

• when you have multiple widgets from the same model

- when your widgets are from diff models but the models are blended