OBIEE Session Variables

Variable	Description
USER	Holds the value the user enters as his or her logon name.
	This variable is typically populated from the LDAP profile of the user.
USERGUID	Contains the global unique identifier (GUID) of the user,
	typically populated from the LDAP profile of the user.
GROUP	Contains the groups to which the user belongs. Exists only for compatibility with previous releases.
	Legacy groups are mapped to application roles automatically.
	When a user belongs to multiple groups, include the group names in the same column,
	separated by semicolons (for example, GroupA;GroupB;GroupC). If a semicolon must be included as part of a group name,
	precede the semicolon with a backslash character (\).
ROLES	Contains the application roles to which the user belongs.
	When a user belongs to multiple roles, include the role names in the same column,
	separated by semicolons (for example, RoleA;RoleB;RoleC).
	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.
PERMISSIONS	Contains the permissions held by the user, such as oracle.bi.server.manageRepositories.
PROXY	Holds the name of the proxy user. A proxy user is a user that has been authorized to act for another user.
	See Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for more information about the PROXY system session variable.
WEBGROUPS	Specifies the Catalog groups (Presentation Services groups) to which the user belongs,
	if any. Note that the recommended practice is to use application roles rather than Catalog groups.
	When a user belongs to multiple Catalog groups, include the Catalog group names in the same column,
	separated by semicolons (for example, WebgroupA;WebgroupB;WebgroupC).
	If a semicolon must be included as part of a Catalog group name, precede the semicolon with a backslash character (\).
DISPLAYNAME	Used for Oracle BI Presentation Services.
	It contains the name that is 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. This variable is typically populated from the LDAP profile of the user.
LOGLEVEL	The value of LOGLEVEL (a number between 0 and 5) determines the logging level that the Oracle BI Server uses for user queries.
	This system session variable overrides a variable defined in the Users object in the Administration Tool.
	If the administrator user (defined upon install) has a Logging level defined as 4 and
	the session variable LOGLEVELdefined in the repository has a value of 0 (zero), the value of 0 applies.
DESCRIPTION	Contains a description of the user, typically populated from the LDAP profile of the user.
USERLOCALE	Contains the locale of the user, typically populated from the LDAP profile of the user.
DISABLE_CACHE_HIT	Used to enable or disable Oracle BI Server result cache hits. This variable has a possible value of 0 or 1.
DISABLE_CACHE_SEED	Used to enable or disable Oracle BI Server result cache seeding. This variable has a possible value of 0 or 1.
DISABLE_SUBREQUEST_CACHE	Used to enable or disable Oracle BI Server subrequest cache hits and seeding. This variable has a possible value of 0 or 1.
SELECT_PHYSICAL	Identifies the query as a SELECT_PHYSICAL query. See "Syntax and Usage Notes for SELECT_PHYSICAL"for more information.
DISABLE_PLAN_CACHE_HIT	Used to enable or disable Oracle BI Server plan cache hits. This variable has a possible value of 0 or 1.
DISABLE_PLAN_CACHE_SEED	Used to enable or disable Oracle BI Server plan cache seeding. This variable has a possible value of 0 or 1.
TIMEZONE	Contains the time zone of the user, typically populated from the LDAP profile of the user.
WEBLANGUAGE	Used for Oracle BI Presentation Services. Holds the Oracle BI Presentation Services user interface display language.
	Users can select a language on the sign-in page for Oracle BI EE, or they can change the language setting on the
	Preferences tab of the My Account dialog after signing in.
AUTHINITBLOCKONLY	Determines if the initialization blocks required for authentication are executed.
	This variable has a value of Yes. The value is case-insensitive.
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).
REQUESTKEY	Used for Oracle BI Presentation Services. Any users with the same nonblank request key share the same
	Oracle BI Presentation Services cache entries.
	This tells Oracle BI Presentation Services that these users have identical content filters and security in the Oracle BI Server.
	Sharing Oracle BI Presentation Services 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, figures 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.

OBIEE Session Variables

Variable	Description
USER	Holds the value the user enters as his or her logon name.
	This variable is typically populated from the LDAP profile of the user.
USERGUID	Contains the global unique identifier (GUID) of the user,
	typically populated from the LDAP profile of the user.
GROUP	Contains the groups to which the user belongs. Exists only for compatibility with previous releases.
	Legacy groups are mapped to application roles automatically.
	When a user belongs to multiple groups, include the group names in the same column,
	separated by semicolons (for example, GroupA;GroupB;GroupC). If a semicolon must be included as part of a group name,
	precede the semicolon with a backslash character (\).
ROLES	Contains the application roles to which the user belongs.
	When a user belongs to multiple roles, include the role names in the same column,
	separated by semicolons (for example, RoleA;RoleB;RoleC).
	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.
PERMISSIONS	Contains the permissions held by the user, such as oracle.bi.server.manageRepositories.
PROXY	Holds the name of the proxy user. A proxy user is a user that has been authorized to act for another user.
	See Oracle Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition for more information about the PROXY system session variable.
WEBGROUPS	Specifies the Catalog groups (Presentation Services groups) to which the user belongs,
	if any. Note that the recommended practice is to use application roles rather than Catalog groups.
	When a user belongs to multiple Catalog groups, include the Catalog group names in the same column,
	separated by semicolons (for example, WebgroupA;WebgroupB;WebgroupC).
	If a semicolon must be included as part of a Catalog group name, precede the semicolon with a backslash character (\).
DISPLAYNAME	Used for Oracle BI Presentation Services.
	It contains the name that is 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. This variable is typically populated from the LDAP profile of the user.
LOGLEVEL	The value of LOGLEVEL (a number between 0 and 5) determines the logging level that the Oracle BI Server uses for user queries.
	This system session variable overrides a variable defined in the Users object in the Administration Tool.
	If the administrator user (defined upon install) has a Logging level defined as 4 and
	the session variable LOGLEVELdefined in the repository has a value of 0 (zero), the value of 0 applies.
DESCRIPTION	Contains a description of the user, typically populated from the LDAP profile of the user.
USERLOCALE	Contains the locale of the user, typically populated from the LDAP profile of the user.
DISABLE_CACHE_HIT	Used to enable or disable Oracle BI Server result cache hits. This variable has a possible value of 0 or 1.
DISABLE_CACHE_SEED	Used to enable or disable Oracle BI Server result cache seeding. This variable has a possible value of 0 or 1.
DISABLE_SUBREQUEST_CACHE	Used to enable or disable Oracle BI Server subrequest cache hits and seeding. This variable has a possible value of 0 or 1.
SELECT_PHYSICAL	Identifies the query as a SELECT_PHYSICAL query. See "Syntax and Usage Notes for SELECT_PHYSICAL"for more information.
DISABLE_PLAN_CACHE_HIT	Used to enable or disable Oracle BI Server plan cache hits. This variable has a possible value of 0 or 1.
DISABLE_PLAN_CACHE_SEED	Used to enable or disable Oracle BI Server plan cache seeding. This variable has a possible value of 0 or 1.
TIMEZONE	Contains the time zone of the user, typically populated from the LDAP profile of the user.
WEBLANGUAGE	Used for Oracle BI Presentation Services. Holds the Oracle BI Presentation Services user interface display language.
	Users can select a language on the sign-in page for Oracle BI EE, or they can change the language setting on the
	Preferences tab of the My Account dialog after signing in.
AUTHINITBLOCKONLY	Determines if the initialization blocks required for authentication are executed.
	This variable has a value of Yes. The value is case-insensitive.
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).
REQUESTKEY	Used for Oracle BI Presentation Services. Any users with the same nonblank request key share the same
	Oracle BI Presentation Services cache entries.
	This tells Oracle BI Presentation Services that these users have identical content filters and security in the Oracle BI Server.
	Sharing Oracle BI Presentation Services 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, figures 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.

OBIEE Presentation Variable Syntax

Usually, we will use presentation variable which holds only one value.

Syntax:

@{Presentation_Variable_Name}

What if , there is a scenario where the user selection in prompt is multiple selection.

Then the normal syntax to call presentation variable doesn't work.

Solution for this scenario is, using the different syntax for presentation variable which contains multiple values.

Syntax:

@{Presentation_Variable_Name}['@']{'Default'}