About BW Cube #

The component Xtract Cube for Alteryx BW Cube data source can be used to extract data from SAP BW InfoProviders (e.g., Cubes) or Queries and process it further in Alteryx.

To Use BW Cube #

Basic knowledge of Xtract for Alteryx is required to understand the following sections, see Getting Started with Xtract for Alteryx.

  1. Drag & drop BW Cube component to your Alteryx workflow.
  2. Select an SAP connection, navigate to Selected Extraction and click [Edit]. The main window of the component opens.

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

Xtract Cube - Functions Overview #

The main window of the BW Cube component consists of two subsections and several buttons:

  • Cube or Query
  • Preview Cube Extractor

Cube or Query

Within the subsection Cube or Query you can search for a Query or a BW Cube / InfoProvider using the Cube or Query Lookup (magnifying glass symbol). The Key Figures, Dimensions and Properties that can be selected for the output are displayed in this subsection.

Preview

The Preview subsection displays the content of the selected Query or a BW Cube / InfoProvider when clicking the [Load Live Preview] button.

Buttons

  • [Extraction Settings] opens the extraction specific settings e.g., Package Size, Row Limit or Automatic Slicing Dimension.
  • [Load live preview] loads a preview of a Query or a BW Cube / InfoProvider.
  • [Show MDX] displays the MDX statement generated for the selection, which will be executed at run-time on the BW system. When the access to BW system is available, you can additionally use the transaction MDXTEST to run the MDX statement.
  • [Edit Variables] allows defining variables.

More information on working with Xtract Cube is provided in the following sections:

Using BW Cube component

Query Variables

BW Cube Settings