Repository Variable in OBIEE

A repository variable is a variable that has a single value at any point in time.

There are two types of repository variables:

• Static — Repository variables whose value persist and do not change until the administrator decides to change them.
• Dynamic — Repository variables whose values are refreshed by data returned from queries.

The administrator creates repository variables using the Oracle BI Administration Tool.

Syntax for Referencing Repository Variable

For displaying repository variables,we should use

“@{biServer.variables.VariableName}” or

“@{biServer.variables['VariableName']}”

For using repository variables in expression,

we should use “VALUEOF(“VariableName”)” for static variable and

we should use “VALUEOF(“Dynamic Initialization Block Name”.“VariableName”)” for dynamic variable