You use the Replacement Path processing type to specify the value that automatically replaces the variable when you execute the query or Web application.
The processing type Replacement Path can be used with characteristic value variables, text variables, and formula variables.
The following options are available:
Text and formula variables with the processing type Replacement Path can be replaced with a corresponding characteristic value. In the variable editor, on the General tab page, you specify under Reference Characteristic the characteristic that is to be referenced by the replacement. On the Replacement Path tab page, you can choose whether the variable is replaced with the From or the To Value and with the Key or the Name of the characteristic value. You can also specify the Offset Start and Offset Length for the output.
Characteristic value variables with the processing type Replacement Path are replaced with the results of a query. In the variable editor, on the Replacement Path tab page, you select the query whose result you want to use as the variable. You can now process the data result of the selected query as a variable in a different query.
Characteristic value variables, hierarchy variables, text variables, and formula variables with the Replacement Path processing type can take their values from a different variable.
The following prerequisites need to be fulfilled:
● The variable must not be input-ready
● The variable must represent a single value
● The source variable must not be a hierarchy node variable
● The source variable must be input-ready
● The source variable must be available in the query
● The source variable must represent a single value or an interval
In the variable editor, on the Replacement Path tab page, you specify the source variable from which the value is to be determined. The value is either determined from the key, the external attribute of the key, the description, or the attribute value. You can specify an Offset Start and an Offset Length for the output here.
The variable is replaced on the variable screen upon each data release.
In the variable editor, on the General tab page, you choose the processing type Replacement Path.
More information: Replacement Path
If you specify a variable as a characteristic value, you do not have to specify a text for the characteristic value right away. Instead, you can fill the text field dynamically and specifically for the characteristic that you use for the variable when you execute the query. To do this, define a text variable with automatic replacement.