Model: Project - Specifications for Dimension Table: CUT OFF DATE

On this page you will find the specifications regarding the Model: Project and Dimension Table: CUT OFF DATE.

Attributes

Attribute	Description (where applicable)
Cut Off Date	Cut Off Date
Cut Off Year	Cut off year
Cut Off Quarter	Quarter, not NLS dependent
Cut Off Date String	Date as string, fixed format, not NLS dependent
Cut Off Month	Month Name
Cut Off Month No	Month Number
Cut Off Month Short	Month short, 3 char, NLS dependent
Cut Off Week No	Week Number
Cut Off Weekday	Week Day
Cut Off Weekday No	Week Day Number
Cut Off Year Month	Year month
Year (Week based)	Year, NLS dependent
Current Month Flag	Current month flag, day in current month
Current Year Flag	Current year flag, day in current yea
Previous Month Flag
Previous Year Flag
Last 12 Months Flag	Last 12 months flag, day between curr month-1 and curr month-12
Last 24 Months Flag	Last24 months flag, day between curr month-24 and curr month-1

Hierarchies

Hierarchy	Level
CutOffMFHy
	Cut Off Year
	Cut Off Quarter
	Cut Off Month
	Cut Off Date
CutOffMSHy
	Cut Off Year
	Cut Off Quarter
	Cut Off Month
CutOffWFHy
	Cut Off Year
	Cut Off Week No
	Cut Off Date
CutOffWSHy
	Cut Off Year
	Cut Off Week No

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table	BI Access View	Referenced Information Source	Recommended Access Type
CUT OFF DATE	DIM_BI_TIME_BI	DIM_BI_TIME	On Line