OBIEE - Request variable

Bi Server Architecture With Client


Request Variables are used to update Session Variables in the scope of a logical sql.

You will find it in a OBIEE logical Sql in its SET VARIABLE part.

For instance :

SET VARIABLE MyYear='2000';SELECT Calendar."Calendar Year" saw_0 FROM SH ORDER BY saw_0

Its aim is to set an OBI server session variable :

  • either System
  • or Non System
  • and without security sensitivity

More: OBIEE - How and where can I set a Request variable (SET VARIABLE) ?


SET VARIABLE MyVariable=MyVale;Logical SQL


  • a string: SET VARIABLE MyVariable='MyString'
  • a date: SET VARIABLE MyDateVariable=date '2013-05-01'
  • a timestamp: SET VARIABLE MyTimeStampVariable=timestamp '2013-05-01 12:12:12'

What is the scope of a request variable in Presentation Service ?

By using a dashboard prompt to define the request variable, the scope of the request variable (as a presentation variable) depend then of the dashboard prompt scope (that you can find in the dashboard prompt definition)

Obiee Dashboard Prompt Scope

Then you can use it exclusively in a dashboard and not for the entire session. For instance, if you leave the dashboard by opening a new report or going into an other dashboard, the value will be reinitialized to the BI server Session Variable.

To modify a repository session variable for the entire session scope, you can fired this odbc function:

call NQSSetSessionValue('Float MyRepositoryVariable=200;')


To set a session non system repository variable

SET VARIABLE MyYear='2000';SELECT Calendar."Calendar Year" saw_0 FROM SH ORDER BY saw_0

Obiee Session Non System Repository Variable

System Repository Variable

To set the log level for further analyse

This variable allow you to set the LOGLEVEL for further analyse.


To disable the query cache hit

The variable DISABLE_CACHE_HIT disable the use of the query cache of OBI Server.


Reference / Documentation

Discover More
Obiee Nqsgetleveldillability
OBIEE - BI Server (JDBC|ODBC) Driver Functions

The Bi Server interface functions permit: to get data dictionary information. to manage the query cache to set a repository session variable You can call them : through a client that provides...
Obiee Variable Manager
OBIEE - BI Server Variables (session and repository)

The OBI Server can handle two types of variable : repository variable: constant or refreshed periodically session variable: depend of the user and are then set up during the login process. system...
Obiee Answers Advanced Sql Clauses
OBIEE - How and where can I set a Request variable (SET VARIABLE) ?

A request variable is an OBI Server Session Variable but with the scope of the request. The value of the session variable will not be change for the session. You can set it up in three main ways : ...
Obiee Session Manager Variables
OBIEE - How to find the value, the data type of a Server variable ?

When you touch variables, you always need to know their values and even more their data type. The session manager is the tool to give you this kind of information. In the Administration Tool, open...
Obiee Session Non System Repository Variable
OBIEE - How to set a server variable with the session type via a dashboard prompt (with a request variable) ?

A common way to set up a request variable in order to set a session repository variable is to create a dashboard prompt. This article show you with the help of the sh schema a little example. The goal...
Obiee11g Lts
OBIEE - Logical Table Source (LTS) (Physical and Logical Column Mappings)

Logical table sources definethe mappings from a single logical table to one or more physical tables. A logical table contains one or more logical table source. The mapping between physical columns and...
Obiee Presentation Variable Date Format
OBIEE - Presentation Variables

The presentation variable is the only variable offer by the presentation service. You can use direct some system presentation variable (pre-populate or system presentation variable). You can set it up...
Obiee11g System Session Variable
OBIEE - System session variables (reserved variables)

System session variables are session variables that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes. System session variables have reserved names, that cannot be used...
Obi Edition
OBIEE 10G - How to set a request/session variable using the Saw Url (Go/Dashboard)

The go url permit you to pass a sql and a filter but what if you need to pass a request variable in order to set a session variable. Security Session variable In the instanceconfig.xml file anywhere...
Obiee Setting Presentation Variable
OBIEE 10G/11G - How to set a presentation variable ?

You can set up a presentation variable: only through the user interface programmatically with javascript is not yet supported And you can use it then in many places : Which means: use...

Share this page:
Follow us:
Task Runner