Characteristic value variables with processing type Replacement Path can be replaced with the results of a query.
Replace Variable With
Select Query.
Query
Using the input help dialog , 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.
Note that, for technical reasons, variables with processing type Replacement from Query cannot be used in restricted key figures or in selection structure elements.
Use of variables with processing type Replacement from Queryin input ready queries in the context of 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 transactional 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.
You want to insert the result of query Top 5 Products as a variable in query Sales - Calendar Year/Month.
You can now insert the variable into query Sales - Calendar Year/Month. This allows you to determine how the sales for these five top-selling products has developed month for month.
Every time you execute query Sales - Calendar Year/Month, query Top 5 Products is executed beforehand (hence pre-query). This can lead to long runtimes. If you do not need to execute the pre-query (if you do not have to determine the top 5 products every time because they only change monthly, for example), we recommend that you use a variable that represents a precalculated value set.
For more information, seeDetails andPrecalculating Value Sets.