Supply Chain Management 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 in the MM/DD/YYYY format. |
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 Week nn 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 Supply Chain Management only:
Variable Name |
Type |
Usage |
Offering |
---|---|---|---|
CURRENT_MONTH_END_DATE_REP_OTBI |
Repository Variable |
Returns the current Gregorian month end date. |
Supply Chain Management |
CURRENT_MONTH_START_DATE_REP_OTBI |
Repository Variable |
Returns the current Gregorian month start date. |
Supply Chain Management |
CURRENT_WEEK_END_DATE_REP_OTBI |
Repository Variable |
Returns the current Gregorian week end date. |
Supply Chain Management |
CURRENT_WEEK_START_DATE_REP_OTBI |
Repository Variable |
Returns current Gregorian week start date. |
Supply Chain Management |
CURRENT_YEAR_END_DATE_REP_OTBI |
Repository Variable |
Returns the current Gregorian year end date. |
Supply Chain Management |
CURRENT_YEAR_START_DATE_REP_OTBI |
Repository Variable |
Returns the current Gregorian year start date. |
Supply Chain Management |
Last_Quarter_Days_OTBI |
Repository Variable |
Returns the number of days from the beginning of the last calendar quarter to the current date. |
Supply Chain Management |
This_Month_Days_OTBI |
Repository Variable |
Returns the number of days since the beginning of the current calendar month. |
Supply Chain Management |
This_Quarter_Days_OTBI |
Repository Variable |
Returns the number of days since the beginning of the current calendar quarter. |
Supply Chain Management |
ToUOM |
Session Variable |
Gets the user report-level reporting unit of measure (UOM), and passes it on to the UOM conversion calculation engine. |
Supply Chain Management |