Skip to content

BW Hierarchy

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

Note

To extract hierarchies from a BW system, use the BW Hierarchy extraction type. To extract hierarchies from an ERP system like ECC or S4, use the ODP extraction type.

Prerequisites

Warning

Missing Authorization.
To use the BW Hierarchy extraction type, access to the designated authority objects (RFC) in SAP must be available. Adjust SAP Authority Objects accordingly.

Create a BW Hierarchy Extraction

  1. In the main window of the Designer, click [New] to create a new extraction. The window "Create Extraction" opens.
    New
  2. Select an SAP Connection from the drop-down menu in Source and enter a unique name for your extraction.
  3. Select the extraction type BW Hierarchy and click [OK]. The main window of the extraction type opens automatically.

The majority of the functions of the extraction type 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.
    hierarchy_main-window_add
  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.
    Look Up Hierarchy
  3. Click [ ]. Search results are displayed.
  4. Select a Hierarchy and click [Select].

The application returns to the main window of the extraction type.

Define the BW Hierarchy Extraction Type

The BW Hierarchy extraction type offers the following options for Hierarchy extractions:

  1. Define the output format of the Hierarchy in the extraction settings . The BW Hierarchy extraction type supports the following output formats:

    Hierarchy-settings

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

  3. Check the General Settings before running the extraction..
  4. Optional: The default value for Date To is 99991231. To change the value, override the dateTo extraction parameter when calling the extraction.
  5. Click [OK] to save the extraction type.

You can now run the extraction, see Run Extractions.

Last update: July 25, 2024