Replacement Path: Replacement with Query 

Use

Characteristic value variables with the processing type Replacement Path can be replaced with the results of a query.

Features

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 with a Query cannot be used in restricted key figures or in selection structure elements.

Example

You want to insert the result for the query Top 5 Products as a variable in the query Sales – Calendar Year/Month.

...

       1.      Select the characteristic Product and from the context menu, choose New Variable. The new variable is displayed.

       2.      From the context menu of the new variable, choose Edit. The Variables Editor appears.

       3.      On the General tab page, enter a description and, if necessary, change the generated technical name.

       4.      On the General tab page, choose the processing type Replacement Path.

       5.      On the Replacement Path tab page, under Replace Variable with, choose the entry Query and under Query using the input help dialog , the query Top 5 Products.

       6.      Choose OK.

You are now able to insert the variable into the 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 the query Sales – Calendar Year/Month, the query Top 5 Products is executed beforehand (= pre-query). This can lead to long run times. 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 pre-calculated value set.

For more information, see Details and Precalculating Value Sets.