Model: Project - Specifications for Dimension Table: ACCOUNT DATE

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

Attributes

Attribute	Description (where applicable)
Account Date	Account Date
Account Date String	Date as string, fixed format, not NLS dependent
Account Month	Account Month
Account Month No	Account Month Number
Account Month Short	Month short, 3 char, NLS dependent
Account Quarter	Quarter, not NLS dependent
Account Week No	Week Number
Account Weekday	Week Day
Account Weekday No	Week Day Number
Account Year	Year, NLS dependent
Account Year Month	Year month
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
Year (Week based)	Year, NLS dependent

Hierarchies

Hierarchy	Level
AccountMFHy
	Account Year
	Account Quarter
	Account Month
	Account Date
AccountMSHy
	Account Year
	Account Quarter
	Account Month
AccountWFHy
	Account Year
	Account Week No
	Account Date
AccountWSHy
	Account Year
	Account 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
ACCOUNT DATE	DIM_BI_TIME_TM	DIM_BI_TIME_BI	DIM_BI_TIME	On Line