You can create links between dimensions in multiple models which come from different connections.

Linked dimensions can be used to create blended charts 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.

You use several data sources in a workbook and any action performed on a dimension affects the same dimension in other data sources in the same way. By default, the ID attribute is used to match members between the linked dimensions.

Here in this blog, we will see how to link two models from different connections. This story contains two models, one is a live connection whereas the other is non-live connection.

Model 1: SAP BW connection

  1. Create a model with non-live connection as shown below
  2. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  3. Select a query
  4. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  5. Drag required dimensions and click on Dimension Presentation. Select ‘KEY’ and ‘TEXT’ of the dimension.
  6. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  7. The ID attribute is used to match members between the linked dimensions.
  8. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  9. The attributes of a dimension must match the attributes of the dimension it is linked to:
    • Description to Description
    • ID to ID
    • ID and Description to ID and Description

    If the attributes don’t match, when a filter is created, information may not be returned.

  10. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  11. Save the above model.

 

Model 2: Live connection

  1. Create another model with non-live connection as shown below
  2. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  3. Choose a live connection from system
  4. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  5. Select a data source and save the Live Model
  6. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  7. Configure the Model
  8. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

 

Link Dimensions

  1. Open the story and select Edit.
  2. Open the Link Dimensions dialog. There are two ways to access the dialog:
  • Select (Link Dimensions) from the menu bar. (All linked dimensions used in the story will be listed. To create a new link select Start a new model link.)
  • Select a chart. In the Builder tab, expand the Data Source list. Select (Link Models).

The Link Dimensions dialog appears.

  1. In the Data area in the toolbar, select (Edit Prompts) and select Link Variables.
  2. Select a model from the list of models included in your story, or select Add Model to search through the models you have access to.
  3. Choose one or more dimensions.
  4. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  5. As shown above, two tables for live and non-live data sources are created along with a filter panel. (The attribute of a dimension must match the attribute of the dimension it is linked to, or when a filter is created, information may not be returned.)
  6. Link dimensions between both models
  7. Select the type of link.
  8. By default, the link option is a Join but you can update the link option to use an Union instead.
  9. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     
    Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

  10. Select Set.
  11. Table data is filtered due to dimension linked. As shown below.
  12. Creating SAP BW based Linked Dimensions (live &import) in SAP Analytics Cloud
     

 

Linked dimensions appear in the dialog. For more details on Linked Dimensions or Data Blending, please refer to https://www.sapanalytics.cloud/blending-datasets/. Get your business users trained on more best practices of SAP Analytics Cloud. Want to know more? Click here to get in touch.

Subscribe to our Newsletter

5600 Tennyson Pkwy
Suite 120
Plano TX 75024.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com