Model: Project - Specifications for Dimension Table: PROJ START DATE

On this page you will find the specifications regarding the Model: Project and Dimension Table: PROJ START 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
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
Proj Start Date	Project Start Date
Proj Start Date String	Date as string, fixed format, not NLS dependent
Proj Start Month	Project Start Month
Proj Start Month No	Project Start Month Number
Proj Start Month Short	Month short, 3 char, NLS dependent
Proj Start Quarter	Quarter, not NLS dependent
Proj Start Week No	Week Number
Proj Start Weekday	Week Day
Proj Start Weekday No	Week Day Number
Proj Start Year	Year, NLS dependent
Proj Start Year Month	Year month
Year (Week based)	Year, NLS dependent

Hierarchies

Hierarchy	Level
ProjStartMFHy
	Proj Start Year
	Proj Start Quarter
	Proj Start Month
	Proj Start Date
ProjStartMSHy
	Proj Start Year
	Proj Start Quarter
	Proj Start Month
ProjStartWFHy
	Proj Start Year
	Proj Start Week No
	Proj Start Date
ProjStartWSHy
	Proj Start Year
	Proj Start 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
PROJ START DATE	DIM_BI_TIME_TM	DIM_BI_TIME_BI	DIM_BI_TIME	On Line