The following section shows how to use the Xtract Cube component.
This component can be used to extract MDX or BICS data from BW InfoProviders (e.g., Cubes) directly or from BW Queries. The BW Queries can be based on all possible InfoProviders.
Look Up a BW Cube or Query #
- In the main window of the component click the [Search] button ( icon). The window “Cube and Query Lookup” opens.
Select the Extractor, Datasource Type and Extraction Settings of the object (1).
Extractor defines if data is extracted using the OLAP BAPI Interface (MDX) or the native BICS Interface. BICS can only be used in combination with the NetWeaver RFC protocol. BICS is still in beta phase. Datasource Type defines if the look up searches for a BEx Query or an InfoProvider. Extraction Settings Only Structure: Only available for the MDX Extractor. Use Only Structure if your BWCube extraction was created in an older software version, see Extraction Settings for more information.
Use BICS fast mode: Only available for the BICS Extractor, see Extraction Settings: Experimental for more information.
- Enter the name of a Query or a BW Cube / InfoProvider in the search bar (2). Use wildcards (*), if needed.
- Click [Search] ( icon) and select the object of your choice from the displayed list (3).
Alternatively click [Direct Load] to skip the lookup and load the BW Cube / InfoProvider directly. [Direct Load] only works if the full name is entered correctly in the search bar.
- Click [OK] to confirm your selection.
Note: Click [Refresh Metadata] to renew metadata. This is necessary if a data source has been adjusted in SAP, another source system has been connected, or the source system has been updated.
Warning! Invalid action
A BW Query must have the attribute Allow External Access to this Query switched on in the BEx Query Designer or the BW Modeling Tool to appear in the list. For additional details see the knowledge base article Allow external access to BW Queries..
MDX versus BICS (beta)
|Syntax in lookup for BEx Queries||
|Syntax in lookup for InfoProivders||
|Wildcards in lookup||The BEx-Query setting “Allow External Access to this Query” is required, see Allow External Access to BW Queries.
example: *0SD_C03_Q0018 instead of 0SD_C03/0SD_C03_Q0018
|not required and therefore not supported|
|Supported InfoProviders||InfoCubes, Multiproviders, Composite Providers||InfoCubes, MuliProviders, Composite Providers, DSOs|
|Column names of Key figures||EnterpriseID||Technical name
If techn. name is empty: name of the base measure.
If name of the base measure is empty: EnterpriseID.
Tip: In case of duplicate names, change the technical name in the BEx Query Designer.
Note: The BICS component is still in beta phase. Contact Theobald Support in case of errors.
Selecting Measure (Key Figures), Dimensions and Properties #
When an object is selected, in the main main window of the component, there is a tree structure at the left hand-side.
The tree structure represents the metadata of the Query (or InfoProvider).
The first directory contains all the measures (key figures) (4). The following directories correspond to dimensions and often contain additional dimension properties (5).
- Select key figures, dimensions, and properties for the extraction.
- Within the key figures directory, click the arrow to display the available units. Select a unit, if needed.
- Click [Load live preview] to display the output with data from BW. If a unit is selected (e.g., currency) the corresponding field is displayed in the preview.
Note: For every selected dimension or property, a key figure and a unit is displayed in the result.
Setting a Dimension Filter #
- Right-click a dimension. The button [Edit Filter] pops-up.
- Click [Edit Filter]. The window “Member Filter” opens. You can set Single Values, define Value Ranges or select a List Parameter.
- Select a single value (6) or click [Add] (7) to add value ranges.
- Define values for filtering. Dynamic parameters are supported, see Runtime Parameters. To use a dynamic list of values, select a List Parameter from the drop-down-menu (8). If needed, delete filters using the [Remove] button ( symbol).
- Click [OK] to confirm. The “Member Filter” window closes.
When filters are applied, a filter symbol appears in the metadata structure.
Note: BW queries often have defined variables to create filter options. To edit variables, see Query Variables.