Use runtime parameters to change dimension filters and variables dynamically during runtime.
Create Runtime Parameters #
- Click Edit Runtime Parameters in the main window of the component to create or edit dynamic runtime parameters.
The window “Edit Runtime Parameters” opens.
- 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. - 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.
- Click [OK] to confirm.
Define Runtime Parameters #
Assign the runtime parameters to variables or dimension filters.
- 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. - 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.
- When the input is set to parameters, you can select a runtime parameter from the drop-down-list (5).