The following section shows how to use the Xtract BW Cube component

Look up a BW Cube or Query #

  1. Click [Search] (binoculars icon) in the main window of the component. Bw-Cube-Data-Source The dialog “Look Up Cube or Query” opens. Query-LookUp
  2. Select InfoCubes or QueryCubes.
  3. Search for Cube Name by using [Search] (binoculars icon), you can use wildcards (*), if needed.
  4. Select an item from the list.
  5. Click [OK] to confirm.

Cube-Details On the left-hand side of the editor all dimensions, measures and dimension properties are shown. These parameters are presented hierarchically in a tree view.

  1. To extract one or more of these cube elements, drag and drop them to the grid on the right-hand side. If you are choosing the property of a dimension that is not yet contained in the result set, the dimension will be added automatically as well.
  2. To select all the properties of a dimension or all key figures, right-click on the correspondent node and select the option Select for Output.
  3. If one or more measure is seleted, the button [Preview}] is activated.
  4. To see the MDX statement that is generated in the background, click the [Show MDX] link at the top of the editor.