Using Variables in the Analytic Query

You can use variables for flexible configuration of queries that are based on a TransientProvider derived from an ODP.

You create variables in the Variables Editor of the BEx Query Designer.

You can reuse characteristic variables if the following conditions are met:

• The variables relate to the same reference characteristic. This is the case, provided that the following requirements are fulfilled:

  • The fields corresponding to the characteristics (to be referenced) of the operational data provider (ODP) are associated with the same master data ODPs (from the Data Extraction ODP type). In other words, they are the representative key fields of these ODPs.

  • The fields corresponding to the query characteristics (to be referenced) of the ODP have semantically identical node properties, for example, "CALDAY".

  • The name of the reference characteristic can be identified using the ODP field name and type properties (internal type, length, conversion exit).

• The variables are used for the same InfoObject.

With authorization-relevant fields, you can specify (in the variable definition and for BW InfoProvider queries) that variables are automatically filled with values from the user's authorization. To do this, use the the Authorization processing type in the Variables Editor.

For more information about defining and using variables, see the documentation for BEx Query Designer.