This articles shows how to link BEx Query and BW Hierarchy extractions in the Tableau destination. By linking the extractions, you can blend data from both data sources into a single sheet.
Prerequisites in Xtract Universal #
- Create a BEx Query extraction as described in Defining a BW Cube Extraction.
- Open the Extraction Settings of the BEx Query and activate Formatted Values.
- Open the Destination Settings of the extraction and set Text as the Column Name Style for Tableau. Note that using Text as the column name style can result in column names that are not unique.
- Create a BW Hierarchy extraction as described in Defining a Hierarchy Extraction.
- Open the Extraction Settings of the Hierarchy and set Representation to Natural:
Creating a Relationship in Tableau #
- Load both extractions into Tableau (1).
- Create a relationship between the data sources by dragging the sheets into the canvas (2). The window “Edit Relationships” opens.
- Select one pair of fields that is to be matched. Add multiple field pairs to create a compound relationship. Matched pairs must have the same data type.
- Close “Edit Relationships” and switch to the Worksheet view (3).
The data sources are now linked and data from both data sources can be blended in a single sheet.
“Not Assigned” Nodes #
In BW Hierarchies, the values that are not assigned to a hierarchy node are gathered under the “Not Assigned” node.
In Tableau the “Not Assigend” node is labeled “Null” and is only displayed if the BEx Query extraction acts as the primary data source. If the BW Hierarchy extraction is acts as primary data source, the “Null” node is not displayed.