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.

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.