Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

This applies to only those planning functions that are included in the workbook on a Button design item.

Types of Variables

Variables that can be created & used in planning functions in Planning Modeler can be of following types:

  • Characteristic Values
  • Hierarchies
  • Hierarchy Nodes
  • Numeric Values in formulas

 Replacement Types for Variables can be:

  • Manual Input, with or without default values
  • Replacement path (from a query result, another variable)
  • Customer Exit
  • SAP Exit
  • Authorizations

Variables can be used at many places in Planning Modeler like Data Slices, Filters, Planning Functions etc. There are two ways to pass values to the variables that are to be used in Planning Functions:

  • With a predefined(fixed) value
  • With a command in the application 

When variable values are passed via a command from the application (BEx Analyzer or Web Application Designer) the planning function must be included in the application as button.

Passing Variable Values

There can be various scenarios for passing value to variable depending on how the variable is configured. All the possible scenarios where replacement type of variable is set as Manual Input are being covered here.

See the attachment   ButtonProperty.jpg  for properties of a button design item in BEx Analyzer with minimum possible static parameters.
Various scenarios of passing variable values:

Fixed Single-value Variable:

  1. Enter VAR_NAME in the Name column and the technical name of the variable in the Value column.
  2. Enter VAR_VALUE in the Name column and the value you want to pass to the function in the Value column.

Dynamic Single-value Variable:

  1. Enter VAR_NAME in the Name column and the technical name of the variable in the Value column.
  2. Enter the excel cells where the variable values are found in the CommandRange box.
  3. Enter the variable VAR_VALUE, index, and value in the excel cells identified by CommandRange as it is done in the static parameters window. In Excel sheet hide these cells and use cell references to other cells for the variable values to provide a more user friendly appearance. For eg. if in excel values are maintained as shown in attachment DynamicSingleValueVariable  then $A$3:$C$3 has to be entered in CommandRange property of Button.

Multiple Fixed Single-value Variables:

  1. Enter VAR_NAME_1 in the Name column and the technical name of the first variable in the Value column.
  2. Enter VAR_VALUE_1 in the Name column and the value you want to pass to the function for the first variable in the Value column.
  3. Enter VAR_NAME_2 in the Name column and the technical name of the second variable in the Value column.
  4. Enter VAR_VALUE_2 in the Name column and the value you want to pass to the function for the second variable in the Value column. For eg. in excel enter the values as shown in attachment  MultipleFixedSingleValueVariables and $A$2:$C$3 in CommandRange property of Button.

Multiple Dynamic Single-value Variables:

  1. Enter VAR_NAME_1 in the Name column and the technical name of the variable in the Value column.
  2. Enter VAR_NAME_2 in the Name column and the technical name of the second variable in the Value column.
  3. Enter the excel cells where the variable values are found in the CommandRange box.
  4. Enter the variable VAR_VALUE_1, index, and value [VAR_VALUE_2, index, and value ..] in the Excel cells identified by command range as it is done in the static parameters window. In Excel sheet hide these cells and use cell references to other cells for the variable values to provide a more user friendly appearance.

SingleRange Variable:

  1. Enter VAR_NAME in the Name column and the technical name of the variable in the Value column.
  2. Enter VAR_VALUE_LOW in the Name column and the lower end of the value range in the Value column.
  3. Enter VAR_VALUE_HIGH in the Name column and the high end of the value range in the Value column.

Multiple Single-values for a Variable:

  1. Enter VAR_NAME in the Name column and the technical name of the variable in the Value column.
  2. Enter VAR_LINES in the Name column and the number of values to be passed in the Value column.
  3. Enter VAR_VALUE in the Name column and the first variable value in the Value column.
  4. Enter VAR_VALUE in the Name column and the second variable value in the Value column, etc.

Hierarchy Node Variable:

  1. Enter VAR_NAME in the Name column and the technical name of the variable in the Value column.
  2. Enter VAR_VALUE in the Name column and the variable value in the Value column.
  3. Enter VAR_NODE_IOBJNM in the Name column and the InfoObject technical name in the Value Column.

Multiple Single-value Hierarchy Node Variable:

  1. Enter VAR_NAME in the Name column and the technical name of the variable in the Value column.
  2. Enter VAR_NODE_IOBJNM in the Name column and the InfoObject technical name in the Value Column.
  3. Enter VAR_LINES in the Name column and the number of values to be passed in the Value column.
  4. Enter VAR_VALUE in the Name column and the first variable value in the Value column.
  5. Enter VAR_VALUE in the Name column and the second variable value in the Value column, etc.


Link to this page: https://wiki.scn.sap.com/wiki/x/84AQB

  • No labels