Characteristic value variables that are defined with the replacement path processing type can be replaced from the CURRENT MEMBER variable, from other variables, and from a query result. You can transfer values between queries with this type of variable by inserting the query result as the variable in a different query. The variable will run as a prequery when you execute the query.
For example, insert the result of the Top 5 Products query into another query, Net order amount - Calendar Year/Month, variably. Execute the Net order amount - Calendar Year/Month query to determine how the net order amount of the top five products has developed on a month-by-month basis.
Note that the prequery is executed each time the query is executed. Running the prequery may contribute to slow performance. If you do not need to execute the prequery every time you run the query, use a variable that represents a precalculated value set, so that the variable values are stored over time.
Characteristic Value Variable with Replacement Path from a Query
The variable accesses the values from an additional query, the prequery.
The prequery is executed each time the result query is executed.
Example: How do the Top 5 Products dynamically determined by the prequery perform in an analysis by month?