Here is the list of System Session Variables and their definitions :
System Session
Variables
|
Definitions
|
PROXY & 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 (non database
users), this variable is populated with the user's full name.
|
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.
|
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.
|
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”).
|
REQUESTKEY
|
Used for Oracle BI Presentation Services. Any users with the
same non blank 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 non alterable elements (for example,
graphics such as GIF files). Such directories begin with sk_.
|
USER
|
OBIEE - 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.
|
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.
|
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.
|
No comments:
Post a Comment