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)
Current Month Flag	Current month flag, day in current month
Current Year Flag	Current year flag, day in current yea
Cut Off Date	Cut Off Date
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 Quarter	Quarter, not NLS dependent
Cut Off Week No	Week Number
Cut Off Weekday	Week Day
Cut Off Weekday No	Week Day Number
Cut Off Year	Cut off year
Cut Off Year Month	Year month
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
Previous Month Flag
Previous Year Flag
Year (Week based)	Year, NLS dependent

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

Project

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
CUT OFF DATE	DIM_BI_TIME_TM	DIM_BI_TIME_BI	DIM_BI_TIME	On Line