Session variables hold predefined values for a user and are initialized when a user logs in to Oracle CRM On Demand. When session variables are initialized, they remain unchanged for the duration of the session. Session variables are private values for a user and each instance of a session variable can be initialized with a different value for different users. You can reference them in the following areas: Title views, Narrative views, Column Filters, Column Formulas, Dashboard Prompts, and so on.
The most common use of a session variable is to reference it in a column filter condition of a report where you want to dynamically limit the results. The limit is based on the value of a session variable, such as the current fiscal year and month.
A session variable is referenced using the syntax NQ_SESSION.{Variable Name}. To use it in a column formula, it is referenced using the syntax VALUEOF(NQ_SESSION.Variable Name).
Session Variable
|
Description
|
CURRENT_DT
|
Current date and time.
|
COMPANY_LANG
|
Company's default language.
|
COMPANY_TIMEZONE
|
Company's default time zone.
|
COMPANY_TMPLT_COUNTRY
|
Company's default country.
|
CONTEXT_ID
|
ID of currently selected custom book or user in the Book selector.
|
CURRENT_MONTH
|
Current fiscal month of the session for the user. The values range from 1 to 12.
|
CURRENT_QTR
|
Current fiscal quarter of the session for the user. The values range from 1 to 4.
|
CURRENT_YEAR
|
Current fiscal year of the session for the user. A four-digit value, for example: 2011.
|
DISPLAYNAME
|
Current user's name.
|
INC_SUBITEM
|
Currently selected value of Include Sub-Items check box in the Book selector.
|
LAST_QTR
|
Previous quarter.
|
LAST_QTR_YEAR
|
Year of the previous quarter.
|
LAST_YEAR
|
Previous year.
|
NEXT_QTR
|
Next quarter.
|
NEXT_QTR_YEAR
|
Year of the next quarter.
|
NEXT_YEAR
|
Next year.
|
PREFERRED_CURRENCY
|
Indicates the currency selection in an Analytics currency prompt.
|
QAGO
|
Date (full date prefixed with fiscal calendar definition code) a quarter ago
|
QTR_BEFORE_LAST
|
Two quarters ago.
|
QTR_BEFORE_LAST_YEAR
|
Year of two quarters ago.
|
REPLUSER
|
Current user's login ID.
|
SERVER_COMPANY_TIMEZONE_OFFSET
|
The offset (in minutes) between the server timestamp and company default timestamp. The value of this variable is set when you log in. The variable is not updated during your session.
|
USER_ALIAS
|
Current user's alias.
|
USER_BUSINESS_UNIT
|
Current user's business unit
|
USER_BUSINESS_UNIT_LEVEL_1
|
Level 1 business unit in user's business unit hierarchy
|
USER_BUSINESS_UNIT_LEVEL_2
|
Level 2 business unit in user's business unit hierarchy
|
USER_BUSINESS_UNIT_LEVEL_3
|
Level 3 business unit in user's business unit hierarchy
|
USER_BUSINESS_UNIT_LEVEL_4
|
Level 4 business unit in user's business unit hierarchy
|
USER_COMPANY_CURCY
|
Company's default currency.
|
USER_COMPANY_TIMEZONE_OFFSET
|
The offset (in minutes) between the user timestamp and company default timestamp. The value of this variable is set when you log in. The variable is not updated during your session.
|
USER_COUNTRY
|
Current user's country
|
USER_DEFAULT_CURCY
|
User's default currency.
|
USER_DEPARTMENT
|
Current user's department
|
USER_DIVISION
|
Current user's division
|
USER_FISCAL_CALENDAR
|
First month of the current user's fiscal year.
|
USER_ID
|
Current user's unique system ID
|
USER_LANG
|
User's default language.
|
USER_LAST_REFRESH_DT
|
The timestamp, in the user’s timezone, of the start of the most recent refresh of the historical data.
|
USER_MANAGER_ALIAS
|
Current user's manager alias
|
USER_REFRESH_COMPLETE_DT
|
The timestamp, in the user’s timezone, of the end of the most recent refresh of the historical data.
|
USER_REGION
|
Current user's region
|
USER_REPORTS_TO
|
Current user's manager
|
USER_ROLE
|
Current user's role
|
USER_SERVER_TIMEZONE_OFFSET
|
The offset (in minutes) between the user timestamp and server timestamp. The value of this variable is set when you log in. It is not updated during your session..
|
USER_SUBREGION
|
Current user's subregion
|
USER_TIMESTAMP
|
The timestamp of the user based on the timezone the setting defined in the user profile. The value of this variable is set when you log in. The variable is not updated during your session.
|
USER_TIMEZONE
|
The timezone description as defined in your user profile. The value of this variable is set when you log in. The variable is not updated during your session.
|
YAGO
|
Date (full date prefixed with fiscal calendar definition code) a year ago.
|
YEAR_MINUS_THREE
|
Three years ago.
|
YEAR_MINUS_TWO
|
Two years ago.
|
YEAR_PLUS_TWO
|
Two years from now.
|