OBIEE - System session variables (reserved variables)

Bi Server Architecture With Client

About

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 for other kinds of variables (such as static or dynamic repository variables and non-system session variables).

System session variables obtain their values from initialization blocks.

Every active BI Server session generates session variables and initializes them. Each session variable instance can be initialized to a different value.

11G 10G
Obiee11g System Session Variable Obiee System Variable

List

PROXY and PROXYLEVEL

PROXY and PROXYLEVEL are used to authenticate proxy users in the act as functionality.

DATA_TZ or DATA_DISPLAY_TZ

time zone setting

DISPLAYNAME

Used for Oracle BI Presentation Services. It contains the name that will be displayed to the user in the greeting in the Oracle BI Presentation Services user interface. It is also saved as the author field for catalog objects. For internal Oracle BI repository users (nondatabase users), this variable is populated with the user's full name.

Obiee System Variable

EMAIL

Contains the user’s default email address for use with Answers. If the delivery option of Answers is enabled, an email device using this address will be created for the user upon first log in. Users can override this address by changing their account settings in Oracle BI Presentation Services.

GROUP

Contains the groups to which the user belongs. These are used by both the Oracle BI Server and Oracle BI Presentation Services. When a user belongs to multiple groups, separate the group names with semicolons. Do not delimit text (for example, do not surround the text with single or double quotes). Use a Varchar column in a database table to contain the group memberships. For example, if a user belonged to groups called Sales US, Sales UK, QA and Dev, and Doc, the text entered into a Varchar data type column in a database table would be: Sales US;Sales UK;QA and Dev;Doc. Note: The Oracle BI Presentation Services Administrator needs to make sure that the names of Presentation Services groups are different from any user IDs that will be used to log on to Oracle BI Presentation Services. If a user and a Presentation Services group share the same name, the user will receive an Invalid Account message when attempting to log on to Oracle BI Presentation Services.

LAST_SYNCH_TIME and THIS_SYNCH_TIME

These two variables are set and tracked by Oracle BI Presentation Services to manage the synchronization of Oracle BI Disconnected Analytics. For more information, refer to Oracle Business Intelligence Disconnected Analytics Administration and Configuration Guide.

LOGLEVEL

The value of LOGLEVEL (a number between 0 and 5) determines the Logging level that the Oracle BI Server will use for user queries. This system session variable overrides a variable defined in the Users object. If the Administrators Users object has a Logging level defined as 4 and the session variable LOGLEVEL defined in the repository has a value of 0 (zero), the value of 0 applies.

PORTALPATH

Used for Oracle BI Presentation Services. It identifies the default dashboard the user sees when logging in (the user can override this preference after logged on here : Settings → My Account → Preferences → “Default Dashboard”). See How To Configure A Default OBIEE Dashboard Or A Welcome Page For All Users Using PORTALPATH Variable

REQUESTKEY

Used for Oracle BI Presentation Services. Any users with the same nonblank request key will share the same Presentation Server cache entries. This tells Oracle BI Presentation Services that these users have identical content filters and security in the Oracle BI Server. Sharing Presentation Server cache entries is a way to minimize unnecessary communication with the Oracle BI Server.

SKIN

Determines certain elements of the look and feel of the Oracle BI Presentation Services user interface. The user can alter some elements of the user interface by picking a style when logged on to Oracle BI Presentation Services. The SKIN variable points to an Oracle BI Presentation Services folder that contains the nonalterable elements (for example, graphics such as GIF files). Such directories begin with sk_. For example, if a folder were called sk_companyx, the SKIN variable would be set to companyx.

Style and skin names cannot include underscores.

USER

OBI Server - User

PASSWORD

OBIEE - Password

WEBGROUPS

Specifies additional groups specific to Oracle BI Presentation Services, if any. The use of Presentation Services groups provides a mechanism for more granular content control.

WEBLANGUAGE

The WEBLANGUAGE variable contains the language of the user. More: OBIEE 10G/11G - WEBLANGUAGE system session variable.

LOCALE

OBIEE two-letter (shown in the LOCALE parameter entry of NQSConfig.INI File)

DISABLE_CACHE_HIT

If this value has the value 1 for a request, then the BI server doesn't try to find a query cache. More … OBIS - Purging / Disabling the Query Cache

DISABLE_CACHE_SEED

If this variable has the value 1, the result will not be seeded in the query cache.

PREFERRED_CURRENCY

This variable store the preferred currency value of the user.

REVERSIBLE_LTS_PRIORITY_SA_VEC

This system session variable permit to indicate the subject area where the priority group of the logical table source can be reversed. It permit with the help of the variable reverse_lts_priority to dynamically select a source at run time.

REVERSED_LTS_PRIORITY_SA_VEC

This system session variable indicate all subject area where the priority group of the logical table source is permantely reversed.

REVERSE_LTS_PRIORITY

This system session variable is much more use as request variable to reverse the value of the priority group of the logical table source.

If REVERSE_LTS_PRIORITY=1:

11g

AUTHINITBLOCKONLY

Determines if the initialization blocks required for authentication are executed. This variable has a value of Yes. The value is case-insensitive.

ROLES

contains the application roles to which the user belongs.

Example:

AuthenticatedUser;BIConsumer;BIAdministrator;BIAuthor

If a semicolon must be included as part of a role name, precede the semicolon with a backslash character (\).

ROLEGUIDS

Contains the global unique identifiers (GUIDs) for the application roles to which the user belongs. GUIDs for application roles are the same as the application role names.

Example:

AuthenticatedUser;BIConsumer;BIAdministrator;BIAuthor

PERMISSIONS

Contains the permissions (application policies) held by the user, such as oracle.bi.server.manageRepositories.

Example:

AtAGlance;
oracle.bi.publisher.accessReportOutput;
oracle.bi.server.manageRepositories;
oracle.bi.scheduler.manageJobs;
oracle.epm.financialreporting.editBatch;
Explore;
oracle.bi.publisher.accessOnlineReportAnalyzer;
oracle.bi.publisher.administerServer;
oracle.epm.essbasestudio.cpadmin;
oracle.bi.publisher.developReport;
oracle.bi.presentation.catalogmanager.manageCatalog;
_all_;
oracle.bi.publisher.accessExcelReportAnalyzer;
_all_;
EPM_Essbase_Calculate;
oracle.bi.publisher.developDataModel;
EPM_Essbase_Filter;
oracle.epm.essbasestudio.viewer;
oracle.bi.publisher.runReportOnline;
oracle.bi.publisher.scheduleReport;
oracle.epm.financialreporting.administerReporting;
_all_;
oracle.epm.financialreporting.accessReporting;
EPM_Calc_Manager_Designer;
EPM_Essbase_Administrator;
EPM_Calc_Manager_Administrator;
oracle.epm.financialreporting.scheduleBatch;
oracle.epm.financialreporting.editReport;
oracle.epm.financialreporting.editBook

USERGUID

Contains the global unique identifier (GUID) of the user.

C95C9C007F2611E1AF748B730F2545A4

GROUPGUID

Contains the global unique identifier (GUID) of the group.

REALM

  • NQ_SESSION.REALM,
  • NQ_SESSION.REALMGUID

TOKENS

  • NQ_SESSION.TOKENS

CURRENCY

  • NQ_SESSION.CURRENCYTAG
  • NQ_SESSION.PREFERRED_CURRENCY

USER

  • NQ_SESSION.ACTUATEUSERID

CONTEXT_ID

(Weblogic|FMW) - Execution Context ID (ECID)

Documentation / Reference





Discover More
Obiee11g View Related Message By Ecid
(Weblogic|FMW) - Execution Context ID (ECID)

When log entries for error messages and warnings are generated across multiple log files, they can be difficult to trace. However, it is possible to view logging information for specific user transactions...
Weblogic Em Application Role
Fusion Middelware - Application Role

Fusion Middelware Application uses a role-based access control model.Security is defined in terms of Application Roles that are mapped to directory server groups and users. Example of mapping between...
Bi Server Architecture With Client
OBI Server - User

User is a system session variable that: represent an account holds the value the user enters as his or her logon name. It is involved: in the authentication security process to set it up and...
Obi Edition
OBIEE - Authorization

Authorization process in an OBIEE context. The object authorization are specified with the help of : Permissions in the BI Server and Privileges in the BI Presentation Service This process is first...
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...
Saw Object
OBIEE - Dashboard

A dashboard consists of one or more pages that can include the following objects: The views of an analyses Alerts from agents Action links and action link menus Images Text Views of folders...
Obi Edition
OBIEE - Delivers

Delivers is an alerting engine to capture and distribute automatically scheduled notifications, alerts and contents Alerts to individuals or groups via multiple channels such as : email, dashboards,...
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 11g Connection Pool Query Only Selectable
OBIEE - Initialization Block

This option will show you all connection pool that are not the first one. This option is designed to check the Initialization block who hold security/important variables. In other word, if the...
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...



Share this page:
Follow us:
Task Runner