Overview of Allocation Variables

Variables assume values that you define for them. You can use them in components while designing allocation rules and templates.

You can create variables from the System View and from within the Component Designer by starting the Variable Designer. When you create a variable within the Component Designer, the variable is associated with the rule that contains the component. You can also create variables from the System View, and associate them with allocation rules, calculation or plan types, databases, or applications that you select.

Two types of variables exist.

• Execution: When the rule is started, the calculation defined for the variable is performed. You can use execution variables in formula, condition, or loop components.

  Note: Execution variables aren't supported in Essbase aggregate storage applications, including those used in Oracle General Ledger.

• Replacement: When you are designing or creating the rule, the variable is substituted with a calculation. You can use replacement variables in formula components.

  You can create several types of execution and replacement variables.

  Note: The variables you can create differ depending on what application type you are working in and whether you are creating an execution or replacement variable.

You can create variables that prompt users to enter information when they start a rule. These runtime prompt variables prompt users for information regarding members, text, dates, or numbers. The prompts indicate the type of data that is expected.

Up to four database objects with which you can associate a variable exist, depending on which application type you are creating a variable for. A variable can exist in multiple objects simultaneously and can have the same name in each object.

• For all user use Application. If you select application, the variable can be used within the application with which you are working when you create the variable.

• For Essbase users use Database. If you select database, the variable can be used within the database you are working when you create the variable.

• For Essbase users use Rule: If you select rule, the variable can be used within the rule with which you are working when you create the variable.