What are the Variables in Oracle OBIEE 11g - Explained | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

What are the Variables in Oracle OBIEE 11g - Explained

There are basically 4 different types of variables in OBIEE 11g.
  1. Session Variables
  2. Repository Variables
  3. Presentation Variables
  4. Request Variables.

Session Variables:
  1. As the name suggests, session variables are created during the creation of session i.e., as soon as a user logs into the BI server.  So, Every login has its own session variable.
  2. There are two types of session variables
    1.  System (which are defined by OBIEE and are reserved)
    2. Non-System which are defined by developers.
    3. Session Variables can be created only through Oracle BI Administration Tool.
Referencing session variable:
For displaying session variables, we should use @{biServer.variables['NQ_SESSION.VariableName']} .
For using session variables in expression, we should use VALUEOF(NQ_SESSION.“VariableName”).
Repository Variables:
  1.  A repository variable is a variable that has a single value at any point in time.
  2. There are two types of repository variables
    1. Static (which changes only if admin or developer changes it value)
    2. Dynamic ( value is refreshed using a query)
    3. Repository variables can be created only through Oracle BI Administration Tool.
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 for dynamic variable VALUEOF(“Dynamic Initialization Block Name”.“VariableName”).
Presentation Variable:
  1. A presentation variable is a variable which can be created as a part of creation of dashboard prompts. Dashboard prompts must be either Column Prompt or Variable Prompt.
  2. The value of presentation variable is set by the prompt for which it is created (upon user selection).
Referencing presentation variable:
For displaying presentation variables, we should use either
  1. @{variables.VariableName}[Format]{DefaultValue}  or
    1. Format and DefaultValue are optional
    2. Format is useful to format the data for e.g., for Date, format can be MM/DD/YYYY. Note: Default Value is not formatted.
    3. @{scope.variables['VariableName']}.
      1. Scope should be used if you create variables with same name.
      2. Scope can be analyses, dashboard etc.
      3. Order of precedence is analyses, dashboard pages, dashboards.
For using presentation variables in expression, we should use @{“VariableName”}{DefaultValue}. Default value is optional.
Request Variable:
  1. Request Variable is used to overwrite the value of session variable and it happens only during request initiation to the database from column prompt.
  2. Can be created only during the creation of column prompt.
Referencing request variable:
Same as presentation variable.


About Sandeep Venu

    Blogger Comment
    Facebook Comment


kalabizo said...

Hi Sandeep,

Thanks for your valuable blog, it's really useful.
I've a question, my OBIEE server exist on linux server and the only way to connect to my repository through BI Administration tool would be online only... The thing is whenever I want to change any of my session variables and try to save it failed. So I want to know if there's any way I can edit session variables from server side like if there's any configuration files I can edit through....?


Top Links

Upgrading BI Publisher

Add Google Search


Change Admin Password

Best Practices


Host Files



Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP


Admin Paswword


Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table


Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error


Pre Requsite

AIX Commands