Transferring Variable Values
Use
You need not only use the static parameters CMD, DATA_PROVIDER_FILTER, PLANNING_FUNCTION_NAME and PLANNING_SEQUENCE_NAME for the Execute Planning Function or Execute Planning Sequence commands, but also transfer variable values for the variables contained in the planning function or planning sequence to the command.
Features
The variables available 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 the variable |
VAR_VALUE_EXT_x |
Characteristic values in external format Key for characteristic value in external display |
Characteristic Value Variables: Interval Variables
Parameter |
Description |
VAR_NAME_x |
Technical name of the variable |
VAR_VALUE_LOW_EXT_x |
“From” characteristic value in external display Key for characteristic value in external display |
VAR_VALUE_HIGH_EXT_x |
“To” characteristic value in external display Key for characteristic value in external display |
Characteristic Value Variables: Selection Option Variables
Parameter |
Description |
VAR_NAME_x |
Technical name of the variable |
VAR_OPERATOR_x |
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_x |
“From” characteristic value in external display Key for characteristic value in external display |
VAR_VALUE_HIGH_EXT_x |
“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_x |
Row properties ● 'I' found values are added, ● 'E' found values are removed. |
Characteristic Value Variables: Variables for Precalculated Value Sets
Parameter |
Description |
VAR_NAME_x |
Technical name of the variable |
VAR_VALUE_EXT_x |
Name of value set |
Variables for Single or Multiple Hierarchy Nodes
Parameter |
Description |
VAR_NAME_x |
Technical name of the variable |
VAR_VALUE_EXT_x |
Node key in external display Key for hierarchy node |
VAR_NODE_IOBJNM_x |
Node characteristic name With characteristic nodes and text nodes, you have to specify the characteristic name 0HIER_NODE. |
Hierarchy, Formula, and Text Variables
Parameter |
Description |
VAR_NAME_x |
Technical name of the variable |
VAR_VALUE_EXT_x |
Hierarchy name, formula value, text |
The following is valid for the above entries in the tables:
● 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 a variables or two single values for two different variables.
● You can also enter the internal value as parameter value rather than "EXT".
Example
The following variables are 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)
The command configuration occurs as usual using one or multiple sequences of the type Name – Index – Value.
Note that the index element in the configuration sequence does not correspond to the parameter index stated above. There can be multiple commands on a design item Button, for example, two planning functions with variables. The index element determines 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 as well as 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 |