Model: CRM - Specifications for Dimension Table: DATE CLOSURE/COMPLETED

On this page you will find the specifications regarding the Model: CRM and Dimension Table: DATE CLOSURE/COMPLETED.

Attributes

Attribute	Description (where applicable)
Closure Date	Date without time stamp.
Closure Date String	The date converted to string according to the format 'YYYY-MM-DD'.
Closure Month	Represents the name of the month with respect to the given date.
Closure Month No	Represents the month of the year with respect to the given date.
Closure Month Short	Represents the short name of the month (MMM) of the year with respect to the given date.
Closure Quarter	Represents the quarter of the year with respect to the given date.
Closure Week	Represents the ISO week number with respect to closure Date.
Closure Weekday	Represents the name of the day with respect to closure Date.
Closure Weekday No	Represents the number of a day in a the week with respect to closure Date.
Closure Year	Represents the year with respect to the given date.
Closure Year Month	Represents a combination of YEAR and MONTH_OF_YEAR in the format "YYYYMM"
Current Month Flag	Represents a flag that is set to 1 if the date represents the current month. Else the value is 0.
Current Year Flag	Represents a flag that is set to 1 if the date represents the current year. Else the value is 0.
Last 12 Months Flag	Represents the name of the month with respect to Start Date.
Last 24 Months Flag	Represents the month of the year with respect to Start Date.
Previous Month Flag	Represents the short name of the month (MMM) of the year with respect to Start Date.
Previous Year Flag	Represents the quarter of the year with respect to Start Date.
Year (Week based)	Represents the ISO year with respect to Start Date.

Hierarchies

Hierarchy	Level
ClosureDateMFHY
	Closure Year
	Closure Quarter
	Closure Month
	Closure Date
ClosureDateMSHy
	Closure Year
	Closure Quarter
	Closure Month
ClosureDateWFHY
	Year (Week based)
	Closure Week
	Closure Date
ClosureDateWSHy
	Year (Week based)
	Closure Week

USED BY MODEL(S)

Model Name

CRM

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
DATE CLOSURE/COMPLETED	DIM_BI_TIME_BI	DIM_BI_TIME_BI	DIM_BI_TIME	On Line