Skip to content

Variables and Filters

This page shows how to use variables and dimension filters to filter the data that is extracted with the BWCube extraction type. There are two options for filtering:

  • Variables are usually defined in SAP to create filter options for BW Queries. They can be edited in the BWCube extraction type.
  • Dimension Filters are defined in the BWCube extraction type to filter data from InfoProviders or BW Queries that do not have variables.

Both filter options allow the use of runtime parameters.

Edit Variables

BW queries often have defined variables to create filter options. Depending on the type of BEx variable (single value, multiple value, interval or complex selection) input fields of the variables are enabled or disabled.

  1. Look up a BEx Query with defined variables .
    Edit Variables Button
  2. Click [Edit Variables] . The window "Edit variables for [name of the query]" opens.
  3. Select a field that uses variables from the drop-down menu .
    selections
  4. Add one or more of the following filter types:
    • Click [Single] to compare the data to a single specified value.
    • Click [Range] to check if the data is (not) within a specified range of values.
    • Click [List] to check if the data is (not) part of a specified list of values.
  5. In the column Sign , select Include to add the filtered data to the output or select Exclude to remove the filtered data from the output.

  6. Select an operator in the column Option . The operator filters data according to the table below.

    Operator Description
    (not) equal to True if data is (not) equal to the content of operand 1.
    at least True if data is greater than or equal to the content of operand 1.
    more than True if data is greater than the content of operand 1.
    at most True if data is less than or equal to the content of operand 1.
    less than True if data is less than the content of operand 1.
    (not) between True if data values do (not) lie between the values of operand 1 and operand 2.
    element of True if data values are part of operand 1. This option is only available for type List.

  7. In the column Value, enter values directly into the input fields Low and High, assign existing runtime parameters or look up pre-defined values in SAP.

    • - Static values: Enter values directly into the Low and High input fields.
    • - Runtime parameters: Select an existing runtime parameter from the drop-down list.
    • - Pre-defined values: If available, select pre-defined values from SAP:
      selections
  8. Click [OK] to confirm your input.
  9. Click [Load live preview] in the main window of the component to check the result of the filter.
    If runtime parameters are defined, you are prompted to populate the parameters with actual values.

Set Dimension Filters

Each dimension of a BEx Query or an InfoCube offers the possibility to set a filter to execute the MDX statement in BW using the selected filter values. Follow the steps below to create dimension filters in the BWCube extraction type.

  1. In the tree structure of the extraction type, right-click a dimension to open the context menu.
    Query Filter
  2. Click [Edit Filter]. The window "Edit Selections" opens.
  3. Add one or more of the following filter types:
    • Click [Single] to compare the data to a single specified value.
    • Click [Range] to check if the data is (not) within a specified range of values.
    • Click [List] to check if the data is (not) part of a specified list of values.
  4. In the column Sign , select Include to add the filtered data to the output or select Exclude to remove the filtered data from the output.
    edit-selections

  5. In the column Option, select an operator . The operator filters data according to the table below.

    Operator Description
    (not) equal to True if data is (not) equal to the content of operand 1.
    at least True if data is greater than or equal to the content of operand 1.
    more than True if data is greater than the content of operand 1.
    at most True if data is less than or equal to the content of operand 1.
    less than True if data is less than the content of operand 1.
    (not) between True if data values do (not) lie between the values of operand 1 and operand 2.
    element of True if data values are part of operand 1. This option is only available for type List.

  6. In the column Value, enter values directly into the input fields Low and High, assign existing runtime parameters or look up pre-defined values in SAP.

    • - Static values: Enter values directly into the Low and High input fields.
    • - Runtime parameters: Select an existing runtime parameter from the drop-down list.
    • - Pre-defined values: If available, select pre-defined values from SAP:
      selections
  7. Click [OK] to confirm your input.
  8. Click [Load live preview] in the main window of the extraction type to check the result of the filter. If runtime parameters are defined, you are prompted to populate the parameters with actual values.

When filters are applied, the symbol is displayed in the treeview of the dimensions.

Last update: July 15, 2024