Siebel Business Analytics Server Administration Guide > Using Variables in the Analytics Repository > Using the Variable Manager >

Creating New Variables


Use the following procedure to create a new variable.

To create a variable

  1. From the Administration Tool menu bar, choose Manage > Variables.
  2. In the Variable Manager dialog box, from the menu bar, choose Action > New, and then choose Repository Variable or Session Variable.
  3. In the Variable dialog box, type a Variable name.

    Names for all variables should be unique. The names of system session variables are reserved and cannot be used for other types of variables.

  4. In the Variables dialog box, in the Type drop-down list, select the type of variable.

    NOTE:  The name of the dialog box depends on the type of variable that you select.

    • For repository variables, choose Static Repository Variable or Dynamic Repository Variable.
    • For session variables, choose Session Variable.
  5. For session variables, you can select the following check box:

    Enable any user to set the value

    NOTE:  This check box allows you to set the session variables after the initialization block has populated the value (at user login) by calling the ODBC store procedure NQSSetSessionValue(). For example, this allows non-administrators to set this variable for sampling.

  6. For a dynamic repository variable or a session variable, use the Initialization Block drop-down list to select an initialization block that will be used to refresh the value on a continuing basis.

    For more information, see Creating and Editing Initialization Blocks.

  7. To add a Default initializer value, perform one of the following steps:
    • To use the Expression Builder, click the ellipsis button to the right of the Default initializer work space. For more information about creating the value, see SQL Logical Operators.
    • Type the value into the Default initializer text box.

      For static repository variables, the value you specify in the Default initializer window persists, and will not change unless you decide to change it. If you initialize a variable to a character string, enclose the string in single quotes ( ' ).

  8. Click OK.
Siebel Business Analytics Server Administration Guide