Create Global Variables

You can save a calculation as a global variable then reuse it in different analyses.

  1. Open the analysis for editing.
  2. In the Selected Columns pane, click Options beside the column name.
  3. Select Edit Formula to display the Column Formula tab.
  4. Click Variable and select Global.
  5. Click Add New Global Variable.
  6. Enter the value for the Name. For example, gv_region, date_and_time_global_variable, or rev_eastern_region_calc_gv.
    The name for a global variable must be fully qualified when referencing the variable, and therefore is prefixed by the text "global.variables". For example, a global variable set to calculate revenue is displayed in the Column Formula dialog as follows:

    "Base Facts"."1- Revenue"*@{global.variables.gv_qualified}

  7. Enter values for the Type and Value.
    • If you’re selecting "Date and Time" as the data type, then enter the value as in the following example: 03/25/2004 12:00:00 AM
    • If you’re entering an expression or a calculation as a value, then you must use the Text data type, as in the following example: "Base Facts"."1- Revenue"*3.1415
  8. Click OK. The new global variable is added to the Insert Global Variable dialog.
  9. Select the new global variable that you just created, and click OK. The Edit Column Formula dialog is displayed with the global variable inserted in the Column Formula pane. The Custom Headings check box is automatically selected.
  10. Enter a new name for the column to which you have assigned a global variable to reflect the variable more accurately.
  11. Click OK.