Default Variables for Web Applications 

Use

Variables play a central role in BW queries. For example, the entire query or only individual parts of the query can be filtered before reading data according to values. There are variables with automatic substitution, substitution from authorizations, or variables that are ready for input.

The variables for Web applications can be processed in the background (without a variable screen) or in the foreground (with a variable screen). In both cases it is desirable to predefine variables through parameterization. Therefore, all types of variables that are ready for input are supported

In contrast to filtering, the external value for predefining has to be specified for the variables. The date, for example, is transferred as it has been entered.

Features

You set default variables by parameterizing the URL. The variable values are separated from each other by different indexes.

The index in the parameter is indicated in the following by '_I'.

Characteristic Value Variables

Parameter variables or variables for several single values are predefined as follows:

Parameter

Description

VAR_NAME_I

Technical name of the variables

VAR_VALUE_EXT_I

Attribute value in external display

Key for characteristic value in external display

Interval variables are predefined as follows:

Parameter

Description

VAR_NAME_I

Technical name of the variables

VAR_VALUE_LOW_EXT_I

"From" characteristic value in external display

Key for characteristic value in external display

VAR_VALUE_HIGH_EXT_I

"To" characteristic value in external display

Key for characteristic value in external display

Selection option variables are predefined as in the following:

Parameter

Description

VAR_NAME_I

Technical name of the variables

VAR_OPERATOR_I

Operator

'EQ' = Individual value

'BT' = Interval

'LT' = Less than

'LE' = Less than or equal to

'GT' = Greater than

'GE' = Greater than or equal to

VAR_VALUE_LOW_EXT_I

"From" characteristic value in external display

Key for characteristic value in external display

VAR_VALUE_HIGH_EXT_I

"To" characteristic value in external display

Key for characteristic value in external display

This value must only be specified with VAR_OPERATOR='BT'.

VAR_SIGN_I

Row effect

'I' found values are added,

'E' found values are removed.

Variables for precalculated value sets are preassigned as follows:

Parameter

Description

VAR_NAME_I

Technical name of the variables

VAR_VALUE_EXT_I

Name of value set

Variables for Single Hierarchy Nodes or Variables for Several Hierarchy Nodes

Parameter

Description

VAR_NAME_I

Technical name of the variables

VAR_VALUE_EXT_I

Node key in external display

Key for hierarchy node

VAR_NODE_IOBJNM_I

Name of the node characteristic

With characteristic nodes and text nodes, you have to specify the characteristic name (0HIER_NODE).

Hierarchy, Formula, and Text Variables

Parameter

Description

VAR_NAME_I

Technical name of the variables

VAR_VALUE_EXT_I

Hierarchy name, formula value, text

Examples

Predefining the parameter variable

http://yourAppServer:yourPort/SAP/BW/BEx?CMD=LDOC&template_id=yourTemplate&var_name_1=myParameterVariable&var_value_ext_1=4711

Predefining the parameter variable (4711) and select options variable (1, 7 to 12)

http://yourAppServer:yourPort/SAP/BW/BEx?CMD=LDOC&template_id=yourTemplate&var_name_1=myParameterVariable&var_value_ext_1=4711&var_name_2=mySelOptVar&var_operator_2=EQ&var_sign_2=I&var_value_low_ext_2=1&var_name_3=mySelOptVar&var_operator_3=BT&var_sign_3=I&var_value_low_ext_3=7&var_value_high_ext_3=12

Predefining hierarchy nodes variable (DE, 0HIER NODE)

http://yourAppServer:yourPort/SAP/BW/BEx?CMD=LDOC&template_id=yourTemplate&var_name_1=myHryNodeVariable&var_value_ext_1=DE&var_node_iobjnm_1=0HIER_NODE