Example: Using a Variable with Replacement from Query

Context

You want to insert the result of the query Top 5 Products as a variable into the query Sales - Calendar Year/Month.

Procedure

  1. Select the characteristic Product and choose New Formula from the context menu. The New BW Variable wizard opens.
  2. Enter a description and a technical name for the new characteristic value variable.
  3. Select variable type Characteristic Value for field Type of Variable.
  4. Select processing type Replacement Path for field Processing By.
  5. Choose Next.
  6. Choose Query as the Replacement Rule.
  7. Choose the query Top 5 Products using the input help.
  8. You have not completed the definition of the variable. Choose Finish. The system creates the variable. The Variables Editor opens and you see the screen area that shows the properties of the variable.

Results

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.