In this section we will extract a BEx query and a BW hierarchy and create a relationship to link both data sources.

Step 1: Create an BEx query extraction.

XU-Tableau-BExQuery

Check the General Settings:

XU-Tableau-BExQuery-Settings

For more information refer to Define a BW Cube Extraction.

Step 2: Create a BW hierarchy extraction.

XU-Tableau-Hierarchy

Check the General Settings to get a Natural representation of the BW hierarchy:

XU-Tableau-Hierarchy-Settings

For more information refer to Define a Hierarchy Extraction.

Step 3: Load both extractions into Tableau and create a relation between them.

Tableau-BExQuery-Datasource

Tableau-BWHierarchy-Datasource

Let’s create a relationship between the data sources linking the fields Sold to party key (bexquery) to Node Name (bwhierarchy).
Select the menu Data -> Edit Relationships. Select Custom and Click on Add. Select Node Name as the primary field. Select Sold to party Key as the secondary field. Click OK.

Tableau-Edit-Relationships

The data sources are now linked and you can blend data from both data sources on a single sheet.

Tableau-Linked-Data-Sources

For more information about defining relationships refer to Tableau Online Help.