Creating Repository Variables in OBIEE

To create a repository 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 > Repository > 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, select the type of variable: Static or Dynamic.

The name of the dialog box changes to reflect the type of variable that you select.

5. (Dynamic repository variables) Use the Initialization Block drop-down list to select an existing initialization block that will be used to refresh the value on a continuing basis.

6. (Dynamic or static variables) 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.

• Type the value into the Default initializer text box.

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

7. Click OK.