OBIEE - BI Server Variables (session and repository)

Bi Server Architecture With Client


The OBI Server can handle two types of variable :

In essence, a repository variable is the default value of a session variable.

The presentation service (dashboard) offers also a variable : The presentation variable

You can see their value and type in the session manager.

You can use them in BI Presentation Service, BI Server and Scheduler.

They are initialized with the help of an init block

Type of server variable

Obiee Variable Manager


A repository variable is a BI server variable that doesn't depend of the user (then of the login process).

You have two kind of repository variable :

  • Static (of a constant)
  • Dynamic (which is calculated/refresh periodically).


Session Variable are the second type of variable and depend of the user. When the user log in BI Presentation Service, they are initialized.

You have two kind of session variable :

  • Session System (reserved by OBIEE)
  • Session Non System (for your own purpose)

Session System

Session System 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 for other kinds of variables (such as static or dynamic repository_variable and nonsystem session variables).

Session Non System

Session Non System variable are variable that you can create for your own purpose. You can set in:


Obiee Session Variable

Enable any user to set the value

You can set the session variable:

Security Sensitive

When using a row-level database security strategy, such as a Virtual Private Database (VPD), the returned data results are contingent on the authorization credentials of the user.

For variables that you are using for authentication, in the Session Variable dialog, select Security Sensitive to identify them as sensitive to security when using a row-level database security strategy. This option ensures that cache entries are marked with the security-sensitive variables, enabling security-sensitive variable matching on all incoming queries.

This parameter is used to determine if the cached result of a logical sql can be shared between different users. See OBIEE - BI Server (JDBC|ODBC) Driver Functions


Documentation / Reference

Discover More
Obiee Row Wise
OBIEE - (Row-wise|List of Values) server variable

A server variable can be initialized to a list of values (vector) with the row-wise initialization option of an Init block. cached This SQL statement populates the variable MY_VARIABLE_NAME with...
Obi Edition
OBIEE - All type of variables

OBIEE offer several variables which can be set : variables from the OBIEE Server known as session and repository variables. This kind of variable can be initiate with the help of SQL statement and...
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...
Bi Server Architecture With Client
OBIEE - BI Server (OBIS|nqsserver|nqs)

OBI Server is also known as: OBIS (Oracle Business Intelligence Server) or nqsserver (The process name) OBI Server is principally a query and analysis server software: that can integrate data...
Obiee Bi Server Patch
OBIEE - BI Server Patch (automatic update with a patch file)

An alternate way of updating the RPD manually is to script it with an XML patch file. In this approach, you don‟t need to open the RPD through an Admin tool. Instead, the values of the variables...
Obiee Database Cast Feature
OBIEE - Cast as date - Which date format to use ?

When you use the cast function to transform a character data type as a date, you may struggle with the date format that you have to give in a formula column because it depends of the configuration. ...
Obiee Connexion Alter Nls Date Format
OBIEE - Connection Script

The connection pool of the physical layer gives the possibility in the Connection Script tab to execute a command script: on connect before query after query on disconnect You can call...
Column Formula
OBIEE - Criteria Tab

The criteria tab of an answer is a GUI that help you to create the logical SQL. In a column formula, you can add: comment a presentation column a presentation variable a bi server variable...
Saw Object
OBIEE - Dashboard Prompt with data level security

Example of dashboard prompt with a data level security. session variablerow-wise Logical SQL Result : Logical SQL Result :
Obiee User Group Permission Filter
OBIEE - Data security (visibility of data)

This article is data security or authorization in OBIEE. Data-level security controls the visibility of data (content rendered in subject areas, dashboards, Oracle BI Answers, and so on) based on the...

Share this page:
Follow us:
Task Runner