The following section describes the functions of the Xtract BW Hierarchy component of Xtract IS.
The Xtract IS 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 BW Hierarchy component, access to the designated authority objects (RFC) in SAP must be available. For more information, see the knowledge base article on SAP User Rights: BW Hierarchies.

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

How to use the Xtract BW Hierarchy component #

  1. A valid connection manager connected to a SAP system must be defined, see section Connection Manager.
  2. Drag the appropriate component from the toolbox and drop it to your data flow task.
  3. Double-click the [icon] of 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 BW Hierarchy component is provided in the following sections.

Defining a BW Hierarchy Extraction

Table Output