Parameter variables

The parameter variables are used in commands to represent the specific context or elements that are replaced at run-time by a value specific to the current context and settings. The parameter variables are validated at run-time. Therefore, all variables are allowed when creating macros, interface services, calculation rules, worksheet parameters, or plansheet parameters. Variables are substituted in Infor BI OLAP before creating the calculation rules (for the cycle period) or when resuming a rule using the Refresh option.
Note: 
  • Variables are not case-sensitive.
  • If the variables are used for macro functionality, only one variable per parameter is allowed.
  • The format used for application variables is app_var_VarName.
  • Application variables are declared at a system level and can be overridden a cycle or Planning Engine level.
  • Application variables are replaced at run-time.
  • The %periodcontextstart% and %periodcontextcount% parameters are used in plansheets with the global period selector to determine the periods that are displayed.
  • The %planning-horizon-startdate% parameter defines the start date of the planning horizon used in planning engine. The date is based on the SCP calendar and must be within the inclusive range of %horizon-start% to %horizon-end%.
  • The %horizon-start% parameter defines the start date of the horizon used in planning engine. The date is based on the date as defined in the SCP calendar.
  • The %planning-horizon-enddate% parameter defines the end date of the planning horizon used in planning engine. The date is based on the date as defined in the SCP calendar and must be within the inclusive range of %horizon-start% to %horizon-end%.
  • The %horizon-end% parameter defines the end date of the horizon used in planning engine. The date is based on the date as defined in the SCP calendar.

    Planning engine bucket end dates are one day greater than the bucket end date as defined in the SCP calendar. For example, FY23 W27 has an SCP Start date of 26/06/2023 and an end date of 02/07/2023, whereas the planning engine for the same period has a start date of 26/06/2023 and an end date of 03/07/2023. The SCP end date is the one used in %planning-horizon-enddate% and %horizon-end%. This is to ensure that data is correctly placed in the appropriate bucket.