| Print Open PDF Version of Online Help

#### Session Variables in Analytics Session variables hold predefined values for a user and are initialised when a user logs in to Oracle CRM On Demand. When session variables are initialised, 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 initialised 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.

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.