About Xtract Hierarchy #

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

To Use Xtract Hierarchy #

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

  1. Drag & drop Xtract 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 Date To is 99991231. To change it, click on Run and override the value in the field dateTo.

Preview

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

Buttons

  • [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.