Creating Session Variables in OBIEE

 

Creating Session Variables

Use this task to create a session variable.

To create a session 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 > Session > Variable.

3. In the Session 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. For session variables, you can select the following check boxes:

Check box that 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-Oracle BI Administrators to set this variable for sampling.

Check box that identifies the variable as sensitive to security for virtual physical databases (VPD). When filtering cache table matches, the Oracle BI Server looks at the parent database of each column or table that is referenced in the logical request projection list. If the physical database source is a VPD, the Oracle BI Server matches a list of security-sensitive variables to each prospective cache hit. Cache hits would only occur on cache entries that included and matched all security-sensitive variables.

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

6. 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.

7. Click OK.