Use runtime parameters to set dimension filters and BEx variable values dynamically during runtime.

Creating Runtime Parameters #

  1. Click [Edit Runtime Parameters] in the main window of the component to create or edit dynamic runtime parameters. The window “Edit Runtime Parameters” opens.
    Add parameters
  2. Click [Add] (1) to define parameters which can be used as placeholders for data filters. These placeholders need to be populated with actual values at extraction runtime.
    Tip: Parameter0..-n is the default naming for the added parameter. You can enter a name of your choice (see the given example: “p_MATNR”).
  3. Open the drop-down menu (2) and assign one of the following data types to the parameter. The data types can, but don’t need to correlate to SAP data types.
    • String: This data type can be used for any type of SAP field.
    • Number: This data type can be used for numeric SAP fields.
    • Flag: This data type can only be used for SAP fields that require an ‘X’ (true) or a blank ‘‘ (false) as input value.
  4. Click [OK] (3) to confirm your input.

Defining Runtime Parameters #

Assign the runtime parameters to BEx 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. If there are runtime parameters, a parameter icon is displayed next to the input fields (4).
    Clicking the icons switches the between entering actual input values and entering parameters.
    Selection With Parameters
  3. When the input is set to parameters, you can select a parameter from the drop-down-list (5).