Session variables are similar to dynamic repository variables in that they obtain their values from initialization blocks. Unlike dynamic repository variables, however, the initialization of session variables is not scheduled. When a USER begins a session, the Oracle BI Server creates new instances of session variables and initializes them.

A repository variable has a single value at any point in time. Repository variables can be used instead of literals or constants in Expression Builder in the Administration Tool. The Oracle BI Server substitutes the value of the repository variable for the variable itself in the metadata.

Unlike a repository variable, there are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each INSTANCE of a session variable could be INITIALIZED to a different value.

(or)

Session variables can have different values for each user, repository variables have the same value for everyone.

There are two TYPES of session variables:

• System session variables: out of the box variables like USER
• Non-system session variables: user-defined variables, can have different values for each user and are typically used to customize user experience , for example you could have a SALES_REGION variable to show only data relevant to the user's region.

Repository variables also have 2 subtypes:

• Static repository variable: Fixed value that can only be changed with the admin tool, can be used to replace hardcoded values like database schemas and user names in connection pools.
• Dynamic repository variable: These hold values that apply to any user, for instance currency exchange rates.

Both System variables and dynamic repository variables get their values from initialization blocks that can contain SQL.

Session variables are similar to dynamic repository variables in that they obtain their values from initialization blocks. Unlike dynamic repository variables, however, the initialization of session variables is not scheduled. When a user begins a session, the Oracle BI Server creates new instances of session variables and initializes them.

A repository variable has a single value at any point in time. Repository variables can be used instead of literals or constants in Expression Builder in the Administration Tool. The Oracle BI Server substitutes the value of the repository variable for the variable itself in the metadata.

Unlike a repository variable, there are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.

(or)

Session variables can have different values for each user, repository variables have the same value for everyone.

There are two types of session variables:

Repository variables also have 2 subtypes:

Both System variables and dynamic repository variables get their values from initialization blocks that can contain SQL.