The following section shows how to use the BW Cube Component.
The BW Cube 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 (magnifying glass symbol). The window “Cube and Query Lookup” opens.
- In the field Name (1) enter a name of a Query or a BW Cube / InfoProvider. Use wildcards (*), if needed.
- Define the Extractor and Type of the object (2).
- 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.
- Type defines if a BEx Query or an InfoProvider is looked up.
- Click [Search] (magnifying glass symbol) (3) and select the object of your choice from the displayed list (4).
- Click [OK] (5) to confirm.
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||supported
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|
|Setting in BEx Query||Setting “Allow External Access to this Query” is required. If not set, BEx Query won’t appear in the lookup, see Allow External Access to BW Queries.||not required|
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) (6). The following directories correspond to dimensions and often contain additional dimension properties (7).
- 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 (8) or click [Add] (9) 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 (10). If needed, delete filters using the [Remove] button (dustbin 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.