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