Replacement from Query
Characteristic value variables with the Replacement Path processing type can be replaced with the results of a query. The variable is replaced from the data result of the selected query.
On the Variable - Replacement Rule dialog in the second step of the variables wizard, you specify that the variable derives its value from the data result of a query. You then select the required query with Browse.
Note that, for technical reasons, variables with processing type Replacement from Query cannot be used in restricted key figures or in selection structure elements.
In BW Integrated Planning, it is not possible to use variables with processing type Replacement from Query in queries that are based on an aggregation level. Instead, use the real-time InfoCube of the aggregation level as an InfoProvider for the query. Note also that the variable with processing type Replacement from Query only contains data that has already been saved.
On the Replacement Path tab of the variables editor, you can select another query if you want to use its data result in future. In addition, you can specify whether this view should be used at the start of the query.