OBIEE - How to find the value, the data type of a Server variable ?

Bi Server Architecture With Client


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.

How to get them ??

With the administration Tool

In the Administration Tool, open the repository in online mode, Menu / Manage / Sessions. You will see then the values of the variable in the bottom of the windows in the tab named variable :

You could not find the value of a session variable modified by the initialization of a request variable because they don't have the same scope. The request variable is available only for a dashboard/answer while the session variable is valid for the whole user session.

Obiee Session Manager Variables

With the NQSGetSessionValues procedure

Programmatically, by using the NQSGetSessionValues procedure, you can get their values.

Obiee Nqsgetsessionvalues


The session variable, , has no value definition. (HY000)

The value in the session manager is likely NULL ?

Discover More
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 Repository Variable Date Type
OBIEE - How to set and use a server variable (system/repository) of type date ?

This article is a tutorial on how to set a date in a server variable (session variable of repository variable) and use it. This article use the schema SH : SH repository installation in the database and...
Bi Server Architecture With Client
OBIEE - Session Manager

The Oracle BI Administration Tool Session Manager is used in online mode to monitor activity. You can see which users are logged in, disconnect users, and terminate queries.The Session Manager shows all...
Obiee 11g My Account Delegate Users
OBIEE 10G/11G - Act as (Proxy user) Functionality

in the privilege“”nqserver.log Process of Authorizing Users to Act for Others 985587.1ACT AS...

Share this page:
Follow us:
Task Runner