CX Sales Repository and Session Variables for Business Intelligence
You can use these repository and session variables 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 |
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 |
These variables are available for CX Sales only.
Variable Name |
Type |
Usage |
Offering |
---|---|---|---|
USER_MAX_TERR_HIER_LEVEL |
Session Variable |
Returns the maximum fixed hierarchy level from Territory Hierarchy for the logged-in user. This variable can be used to dynamically retrieve the maximum territory level that the logged-in user owns. |
Customer Experience |
USER_ORG_HIER_LEVEL |
Session Variable |
Holds the hierarchy level within the organization selected by the user in a report. |
Customer Experience |
USER_PARTY_ID |
Session Variable |
Stores the PARTY_ID from UserPVO. |
Customer Experience |
CURRENT_ENTERPRISE_PERIOD |
Repository Variable |
Returns the value of the Current Fiscal Period. |
Customer Experience |
CURRENT_ENTERPRISE_PERIOD_END_DATE |
Session Variable |
Returns the End date of Current Enterprise Period. |
Customer Experience |
CURRENT_ENTERPRISE_QUARTER |
Repository Variable |
Returns the value of Current Enterprise Quarter in the YYYY Q n format. |
Customer Experience |
CURRENT_ENTERPRISE_QUARTER_END_DATE |
Session Variable |
Returns the End date of Current Enterprise Quarter. |
Customer Experience |
CURRENT_ENTERPRISE_YEAR |
Repository Variable |
Returns the value of Current Enterprise Week in the YYYY Week format. |
Customer Experience |
NEXT_ENTERPRISE_PERIOD |
Repository Variable |
Returns the value of Next Enterprise Period. |
Customer Experience |
NEXT_ENTERPRISE_QUARTER |
Repository Variable |
Returns the value of Next Enterprise Quarter in the YYYY Q n. |
Customer Experience |
NEXT_ENTERPRISE_YEAR |
Repository Variable |
Returns the value of Next Enterprise Year in the FYYYYY format. |
Customer Experience |
PREVIOUS_ENTERPRISE_PERIOD |
Repository Variable |
Returns the value of Previous Enterprise Period. |
Customer Experience |
PREVIOUS_ENTERPRISE_QUARTER |
Repository Variable |
Returns the value of Previous Enterprise Quarter in the YYYY Q n format. |
Customer Experience |
PREVIOUS_ENTERPRISE_YEAR |
Repository Variable |
Returns the value of Previous Enterprise Year in the FYYYYY format. |
Customer Experience |
SVC_SR_ASSIGN_INIT_DT |
Session Variable |
Returns a date when the POD was upgraded to latest version. |
Customer Experience |