Use runtime parameters to change dimension filters and variables dynamically during runtime.

Create 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 Scalar] to define scalar parameters that can be used as placeholders for filters.
    Click [Add List] to define list parameters that can be used as placeholders for dimension filters with multiple members.
    The placeholders need to be populated with actual values at extraction runtime. List parameters contain a list of values separated by commas e.g., 1,10 or “1”, “10”.
    Tip: Parameter0..-n is the default naming for the added parameter. You can enter a name of your choice.
  3. Open the drop-down menu 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] to confirm.

Adding Scalar Parameters

Add Scalar

Adding List Parameters

Add List

Define Runtime Parameters #

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