Xtract Hierarchy

This page shows how to use the Xtract Hierarchy component. The Xtract Hierarchy component can be used to extract Hierarchies and InfoObjects from SAP BW systems.

Prerequisites

• A connection to an SAP system is available, see SAP Connection.
• The SAP user has sufficient user rights, see SAP Authority Objects.

Add an Xtract Hierarchy Component

Follow the steps below to add an Xtract Table component to your SSIS package:

1. Drag&drop the Xtract Hierarchy component from the SSIS toolbox into your data flow task.
   

2. Double-click the component. A connection manager is automatically assigned to the component and the main window of the component opens.

   Note

   If there are multiple connection managers, the window "Select Connection Manager" opens, see SAP Connection. Once a connection manager is selected, the main window of the component opens.

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

Look Up a Hierarchy

1. In the main window of the component, click [ ]. The window “Hierarchy Lookup” opens.
   
2. Enter the name of a Hierarchy in the field Hierarchy Name or the name of an InfoObject in the field InfoObject . Use wildcards (*) if needed.
   
3. Click [ ]. Search results are displayed.
4. Select a Hierarchy and click [Select].

The application returns to the main window of the component.

Define the Xtract Hierarchy Component

The Xtract Hierarchy component offers the following options for Hierarchy extractions:

1. Define the output format of the Hierarchy in the settings . The Xtract Hierarchy component supports the following output formats:

   • ParentChild Format
   • Natural Format
   • ParentChildWithNodeNames Format

   

2. Click [Load live preview] to display a live preview of the first 100 records.

3. Click [OK] to save the component.

You can now run the SSIS package.

Related Links

• Settings
• SAP Help: Uploading Hierarchies from Flat Files