Repository and Session Variables for Business Intelligence

This table shows repository and session variables available for use in your analyses.

Variable Name	Type	Usage	Offering
CURRENT_DAY	Session Variable	Returns the value of Current Date.	All
CURRENT_MONTH	Repository Variable	Returns the value of Current Month in the YYYY/MM format.	All
CURRENT_WEEK	Repository Variable	Returns the value of the current week in YYYY Weeknnn format.	All
CURRENT_QUARTER	Repository Variable	Returns the value of Current Quarter in YYYY Q n format.	All
CURRENT_YEAR	Repository Variable	Returns the value of Current Year in the YYYY format.	All
DISPLAYNAME	Session Variable	Returns the user name displayed to the user in the greeting, used as the author field for catalog objects when they're saved.	All
NEXT_MONTH	Repository Variable	Returns the value of Next Month in the YYYY / MM format.	All
NEXT_WEEK	Repository Variable	Returns the value of Next Week in the YYYY Week nn format.	All
NEXT_QUARTER	Repository Variable	Returns the value of Next Calendar Quarter in the YYYY Q nn format.	All
NEXT_YEAR	Repository Variable	Returns the value of Next Year in the YYYY format.	All
PREVIOUS_MONTH	Repository Variable	Returns the value of Previous Month in the YYYY/MM format.	All
PREVIOUS_WEEK	Repository Variable	Returns the value of Previous Week in the YYYY Week nn format.	All
PREVIOUS_QUARTER	Repository Variable	Returns the value of Previous Quarter in the YYYY Q nn format.	All
USER	Session Variable	Holds the value the user enters when logging in.	All