Xtract BW Cube

This page shows how to use the Xtract BWCube component.
The Xtract BWCube component can be used to extract MDX or BICS data directly from BW InfoProviders (e.g., Cubes) or from BW Queries. The BW Queries can be based on InfoProviders.

Prerequisites

• A connection to an SAP system is available, see SAP Connection.
• The SAP user has sufficient user rights, see SAP Authority Objects.
• To extract a BW Query, the attribute Allow External Access to this Query of the Query must be active in the BEx Query Designer or the BW Modeling Tool, see Troubleshooting Article: Allow external access to BW Queries.

Add an Xtract BW Cube Component

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

1. Drag&drop the Xtract BW Cube 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 BW Cube or Query

By default, the Xtract BWCube component extracts data using the MDX interface.
To use BEX mode or to enter MDX statements, change the settings before the looking up a BW Cube or Query.

1. In the main window of the component, click the search botton. The window “Cube and Query Lookup” opens.
2. Select the type of cube you want to extract data from (Info Cube or Query) .
   
3. In the search bar, enter the name of a Query or a BW Cube / InfoProvider . Use wildcards (*), if needed.
4. Click the search button. Search results are displayed.
5. Select a Query or BW Cube / InfoProvider and click [OK] to confirm.

The application now returns to the main window of the component.

Define the Xtract BWCube Component

The Xtract BWCube component offers the following options for Query and BW Cube extractions:

1. In the tree structure of the component, double-click the measure (key figures) you want to extract.
   

   Tip

   The tree structure represents the metadata of the Query (or InfoProvider).
   The first directory contains all the measures (key figures) . The following directories correspond to dimensions and often contain additional dimension properties .

2. Within the key figures directory, click the arrow to display the available units. Select a unit, if needed.

3. In the following directories, select the dimensions and properties you want to extract .
4. Optional: Click the Filter option next to a dimension to add filters , see Dimension Filters.
5. Optional: If a BW Query has a defined variable, click Variables to edit the variable or provide input values, see Variables.
6. Click [Preview] to display a live preview of the data. For every selected dimension or property, a key figure and a unit is displayed in the result.
7. Check the Settings before running the SSIS package.
8. Click [OK] to save the component.

You can now run the SSIS package.