Setting Variable Target Units of Measure in the Query Designer 

Prerequisites

You have created a quantity conversion type. You have selected the Selection of Unit of Measure During Conversion option on the Unit of Measure tab page in this conversion type.

Procedure

...

       1.      You are in the Query Designer. In the properties for your amount key figure, choose the Translations tab page.

       2.      Under Unit Conversion, select your conversion type.

       3.      Select the Variables Entry field and choose New Variable. The variables editor appears. See also Defining Variables.

       4.      Enter a description for the variable.

       5.      If necessary, change the automatically generated suggestion for the technical name of the variable.

       6.      In the Processing by field, choose the processing type User Entry/Default Value. The unit of measure characteristic (0UNIT) is the default.

       7.      Under Details, specify whether the entry is to be:

○     Optional

○     Mandatory

○     Mandatory, initial values not permitted

       8.      Allocate a default value for the variable.

       9.      Choose OK. The variable is saved with the settings you made and the variable editor closes.

Result

When you execute the query the system requests the variable for the target unit of measure.