Passing Variable Values
Besides using the static parameters CMD, DATA_PROVIDER_FILTER, PLANNING_FUNCTION_NAME and PLANNING_SEQUENCE_NAME for the Execute Planning Function or Execute Planning Sequence commands, you can also transfer variable values for the variables contained in the planning function or planning sequence to the command.
The available variables are listed below.
Characteristic value variables
Characteristic value variables: parameter variables or variables for multiple single values
|
Parameter |
Description |
|
VAR_NAME_x |
Technical name of variable |
|
VAR_VALUE_EXT_x |
Characteristic value in external display Key of characteristic value in external display. |
Characteristic value variables: interval variables
|
Parameter |
Description |
|
VAR_NAME_x |
Technical name of variable |
|
VAR_VALUE_LOW_EXT_x |
'From' characteristic value in external display Key of characteristic value in external display. |
|
VAR_VALUE_HIGH_EXT_x |
'To' characteristic value in external display Key of characteristic value in external display. |
Characteristic value variables: selection option variables
|
Parameter |
Description |
|
VAR_NAME_x |
Technical name of variable |
|
VAR_OPERATOR_x |
Operator 'EQ' = Single 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_x |
'From' characteristic value in external display Key of characteristic value in external display. |
|
VAR_VALUE_HIGH_EXT_x |
'To' characteristic value in external display Key of characteristic value in external display. This value must only be specified with VAR_OPERATOR='BT'. |
|
VAR_SIGN_x |
Effect of Row
|
Characteristic value variables: Variables for precalculated value sets
|
Parameter |
Description |
|
VAR_NAME_x |
Technical name of variable |
|
VAR_VALUE_EXT_x |
Name of value set |
Variables for individual or multiple hierarchy nodes
|
Parameter |
Description |
|
VAR_NAME_x |
Technical name of variable |
|
VAR_VALUE_EXT_x |
Node key in external display Key of hierarchy node. |
|
VAR_NODE_IOBJNM_x |
Name of node characteristic With characteristic nodes and text nodes, you have to specify the characteristic name 0HIER_NODE. |
Hierarchy variables, formula variables and text variables
|
Parameter |
Description |
|
VAR_NAME_x |
Technical name of variable |
|
VAR_VALUE_EXT_x |
Hierarchy name, formula value, text |
The following applies to the table entries explained above:
-
Placeholder for the parameter index is "x". All single values (value rows) are numbered sequentially using the parameter index, irrespective of whether they represent multiple single values for variables or two single values for two different variables.
-
Instead of "EXT", you can specify the internal value as the parameter value.
The following variables, used in the subsequent examples, all are defined by the 0CALMONTH characteristic:
-
MY_VAR_MULT_SINGLE (type: variable for multiple single values)
-
MY_VAR_SO_FROM (type: selection option variable)
-
MY_VAR_SO_TO (type: selection option variable)
-
MY_VAR_NODE (type: variable for multiple hierarchy nodes)
Commands are configured in the usual was, using one or more of these sequences: Name - Index - Value.
Note that the index element in the configuration sequence does not correspond to the parameter index stated above. Multiple commands are possible on a Button design item. For example, two planning functions with variables. The index element defines the execution sequence of commands.
For more information, see Button.
Example: Transferring a Single Value to MY_VAR_MULT_SINGLE
|
Name |
Index |
Value |
|
VAR_NAME_1 |
1 |
MY_VAR_MULT_SINGLE |
|
VAR_VALUE_LOW_EXT_1 |
1 |
03.2003 |
The following example shows the transfer of a single value to the selection option variable MY_VAR_SO_FROM. It also shows the transfer of single values and an interval to the selection option variable MY_VAR_SO_TO:
Example: Transfer to MY_VAR_SO_FROM and MY_VAR_SO_TO
|
Name |
Index |
Value |
|
VAR_NAME_1 |
1 |
MY_VAR_SO_FROM |
|
VAR_VALUE_LOW_EXT_1 |
1 |
01.2003 |
|
VAR_SIGN_1 |
1 |
I |
|
VAR_OPERATOR_1 |
1 |
EQ |
|
VAR_NAME_2 |
1 |
MY_VAR_SO_TO |
|
VAR_VALUE_LOW_EXT_2 |
1 |
02.2003 |
|
VAR_SIGN_2 |
1 |
I |
|
VAR_OPERATOR_2 |
1 |
EQ |
|
VAR_NAME_3 |
1 |
MY_VAR_SO_TO |
|
VAR_VALUE_LOW_EXT_3 |
1 |
04.2003 |
|
VAR_SIGN_3 |
1 |
I |
|
VAR_OPERATOR_3 |
1 |
BT |
|
VAR_VALUE_HIGH_EXT_3 |
1 |
06.2003 |
The following example shows the transfer of the scroll 02.2003 (February 2003) and the node 3.2003 (3rd quarter 2003) from a hierarchy on 0CALMONTH to MY_VAR_NODE. The node is defined on the external characteristic 0CALQUARTER.
Example: Transfer to MY_VAR_NODE
|
Name |
Index |
Value |
|
VAR_NAME_1 |
1 |
MY_VAR_NODE |
|
VAR_VALUE_EXT_1 |
1 |
02.2003 |
|
VAR_NODE_IOBJNM_1 |
1 |
|
|
VAR_NAME_2 |
1 |
MY_VAR_NODE |
|
VAR_VALUE_EXT_2 |
1 |
3.2003 |
|
VAR_NODE_IOBJNM_2 |
1 |
0CALQUARTER |