The following section describes the functions of the Xtract Hierarchy component of Xtract IS.
The Xtract Hierarchy component is an SSIS data source that enables the extraction of hierarchies from an SAP BW / BI system.

Warning! Missing Authorization To use the Hierarchy component, access to the designated authority objects (RFC) in SAP must be available. For more information, refer to the knowledge base article SAP User Rights: BW Hierarchies.

Note: To extract hierarchies from a BW system, use the Xtract Hierarchy component. To extract hierarchies from an ERP system like ECC or S4, use the ODP component.

Tip: To get information on the basics, refer to Getting Started with Xtract IS.

How to use the Xtract Hierarchy component #

  1. Define a valid connection manager that connects to an SAP system, see Connection Manager.
  2. Drag&drop the Xtract component from the SSIS toolbox into your data flow task.

  3. Double-click the component. The main window of the component opens. The majority of the functions of the component can be accessed using the main window.

More information on working with the Xtract Hierarchy component is provided in the following sections.

Defining a BW Hierarchy Extraction


Table Output