Replacement Path: Replacement with Query 

Definition

A step in the variable wizard that appears for characteristic value variables with the processing type Replacement Path.

Use

Characteristic value variables with the processing type Replacement Path are replaced by the results of a query.

Select the query whose result you want to use as the variable. You can now use the data result of the selected query as a variable in a different query.

Please note that, for technical reasons, variables with processing type Replacing from 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 Variable Wizard appears.

       2.      Enter a variable name and a description.

       3.      Choose the processing type Replacement Path.

       4.      Choose Next. You reach the Replacement Path dialog step.

       5.      Enter the query Top 5 Products.

       6.      Choose Next. You reach the Save Variable dialog step.

       7.      Choose Exit.

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 (that is, if you do not have to determine the top 5 products every time because change monthly, for example), we recommend that you use a variable that represents a pre-calculated value set.

For more information, see Details Defining the Value Set Setting.