Use runtime parameters for dynamic Query Variables or Dimension Filters.

Create Runtime Parameters #

Follow the steps below to create runtime parameters:

  1. In the main window of the component click Edit Runtime Parameters. The window “Edit Runtime Parameters” opens.
    Edit runtime parameters
  2. Click [Add Scalar] or [Add List] (1) to create a scalar or list parameter that can be used a placeholder for values. List parameters can contain multiple values separated by commas e.g., 1,10 or “1”, “10”. The placeholders need to be populated with actual values at runtime.
    Tip: Parameter0..-n is the default naming for the added parameter. You can enter a name of your choice.
    ODP Add parameters
  3. Click on the drop-down menu (2) and assign one of the following data types to a parameter. The data types can, but don’t have to correlate to SAP data types.
    String: This data type can be used for any type of SAP selection field.
    Integer / Number: This data type can be used for numeric SAP selection fields.
    Flag: This data type can only be used for SAP selection fields, which require an ‘X’ (true) or a blank ‘‘ (false) as input value.
  4. Click [OK] (3) to confirm.

Runtime parameters are overwritten at runtime, see Extraction Parameters - Custom

Note: In the BWCube component, runtime parameters usually represent key values. The filter options of BWCube do not support filtering text descriptions.

Adding Scalar Parameters

Add Scalar

Adding List Parameters

Add List

Assign Runtime Parameters #

Follow the steps below to assign the runtime parameters to variables or dimension filters.

  1. To use the runtime parameters as variables, click [Edit Variables] in the main window of the component. The window “Edit variables…” opens, see Variables.
    To use the runtime parameters as dimension filters, right-click a dimension in the main window of the component, then click Edit Filters. The window “Member Filter” opens, see Setting a Dimension Filter.
  2. Click the icon next to the input field to switch from static values ( Assign parameters) to runtime parameters ( Assign parameters). If no icon is available, create a runtime parameter.
    Selection With Parameters
  3. Select a runtime parameter from the dropdown-list (5).
  4. Click [OK] to confirm the input.