You define variables as placeholders that are filled with values at query runtime.
You have called the variable editor in the Query Designer. For more information, see Calling the Variable Editor.
The variable editor automatically provides you with only those selection options that are allowed for the combination of variable type and processing type. For more information, see Variable Types and Processing Types: An Overview.
You make the required settings on tab pages:
This tab page displays the type of the variable. You determine the type of the variable by calling up the variables editor in a specific context.
For example, if you choose New Variable from the context menu of a characteristic value and then call up the variables editor using Edit, the type Characteristic Value is displayed automatically in the variables editor.
1. Enter a description for the variable.
2. If necessary, change the automatically generated suggestion for the technical name of the variable. The generation rule for the technical name is VAR_<date><time> (example: VAR_20050818122045). You can change the generated suggestion for the technical name as long as you have not yet saved the variable. The technical name of each query must be unique.
3. In the Processing by field, choose the processing type for the variable. The type of variable dictates which processing types appear for you to choose from in the dropdown box. For more information, see Variable Processing Types.
4. In the Reference Characteristic field, select the InfoObject on which the variable is to be based.
In the case of characteristic value variables, the default reference characteristic is the characteristic for which you are defining the variable. You can also use the dropdown box to select the basis InfoObject that the characteristic references. The variable is then defined on the basis InfoObject.
The characteristic reference is not shown for text and formula variables with the processing type Replacement Path. You must therefore use the dropdown box to select the characteristic to which the variable relates. The system provides a choice of all InfoObjects and basis InfoObjects that are contained in the InfoProvider on which the query is based.
The ability to define variables both on the basis InfoObject and on derived InfoObjects allows a higher level of reusability for variables. Because InfoSets contain many InfoObjects with the same basic InfoObject, it makes sense to define variables on the basic InfoObject, particularly when using InfoSets as query InfoProviders.
In your BI system, you defined the characteristic CUSTOMER and derived a further characteristic from this: MANUFACTURER. Both characteristics have the same variables. When you create new variables you can choose whether the variables are to reference CUSTOMER or MANUFACTURER.
For example, the left-hand screen area (InfoProvider) in the Query Designer lists both the variables that were created for MANUFACTURER (beneath MANUFACTURER) and the variables that were created for CUSTOMER (beneath CUSTOMER).
The tab pages that are available depend on the variable type and the processing type that you chose. You make the required settings on these tab pages.
Here, the unique ID (UID) that is used for unique identification is displayed. The UID represents the database key under which the variable is saved. This field is only used for information purposes. For example, you can use the UID in URLs of the Web API to address this element. However, we recommend that you use technical names, because UIDs can change when an object is deleted and then re-created. In addition, you can specify the UID when contacting SAP support, as this helps to solve problems quickly.
Choose OK. The variable is saved with the settings you made and the variables editor closes.
You have defined a variable. The changed variable can now be used in all queries.