Defining Variables

To define one or more variables for the model, follow these steps.

Procedure

  1. On the Model screen, select (Variables).
  2. Select (Add).
  3. Enter a Variable ID for the new variable.
  4. (Optional) You can enter a description of the variable.
  5. Select a Value Domain.
    These are the options available for the value domain:
    • For a variable that takes a numeric value, choose Number.
    • To define a variable related to a Date dimension, one or more date options (for Year, Quarter, Month, etc.) are available depending on the granularity settings defined. This type can be used, for example, with the predefined CAGR formula.
    • The list box also includes a reference to each added dimension in the model (based on the Dimension ID attribute). This type can be used, for example, with the predefined Lookup formula.
  6. (Optional) Set a Default Value.
    If the variable relates to an existing dimension, you can choose to select a member of the dimension the variable relates to.
  7. To use the variable in a formula, simply enter the formula in the normal way.
    The variables you have defined will be included in the drop-down list boxes.