You use the Replacement Path processing type to specify the value that automatically replaces the variable when you execute the query or Web application.
Processing type Replacement Path can be used with characteristic value variables, text variables and formula variables.
The following options are available:
Replace with Characteristic Value
Text and formula variables with the processing type Replacement Path can be replaced with a corresponding characteristic value. In the Variables Editor, on the General tab page under Reference Characteristic, you specify 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.
CURRENT MEMBER Variables
To define filters that relate to the values of a time characteristic in the drilldown of a query during analyses, define a restricted key figure using a CURRENT MEMBER variable. This is a variable with the replacement path CURRENT MEMBER. The CURRENT MEMBER variable can be used in restricted key figures as either the lower limit or the upper limit in combination with an offset. Only one restriction with a CURRENT MEMBER variable is allowed per restricted key figure however.
Replace with Query
Characteristic value variables with the processing type Replacement Path are replaced with the results of a query. In the Variables 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.
Replace with Variable
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 apply:
Variable
Source Variable
In the Variables Editor, on the Replacement Path tab page, you specify the source variable from which the value is to be determined. The value is determined either 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 in the Variables screen with each data release.
In the Variables 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. You can fill the text field dynamically and specifically for the characteristic that you use for the variable when you execute the query instead. To do this, define a text variable with automatic replacement.