About BW Hierarchy #

The component BW Hierarchy enables the extraction of hierarchies from an SAP BW system.

To Use BW Hierarchy #

Basic knowledge of Xtract for Alteryx is required to understand the following sections, see Getting Started with Xtract for Alteryx.

  1. Drag & drop BW Hierarchy component to your Alteryx workflow.
  2. Select an SAP connection, navigate to Selected Extraction and click [Edit]. The main window of the component “Hierarchy Extractor” opens.

The majority of the functions of the component can be accessed using the main window.

Hierarchy Extractor - Functions Overview #

The window “Hierarchy Extractor” consists out of two subsections:

  • Hierarchy Extraction
  • Preview

Hierarchy Extractor

Hierarchy Extraction

Within the subsection Hierarchy Extraction you can search for SAP BW hierarchies using the Hierarchy Lookup (magnifying glass symbol). Hierarchy search

Date To
The default value for the field Date To is 99991231. To change the value, click [Run] and override the value.


The Preview subsection displays the fields of the selected SAP BW hierarchy, when clicking the [Load Live Preview] button. Hierarchy preview


  • [Extraction Settings] opens the extraction specific settings e.g., representation or level count.
  • [Load Live Preview] loads a preview of the hierarchy without executing an extraction.