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 Year	Year, NLS dependent
Account Quarter	Quarter, not NLS dependent
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 Week No	Week Number
Account Weekday	Week Day
Account Weekday No	Week Day Number
Account 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
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

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
ACCOUNT DATE	DIM_BI_TIME_BI	DIM_BI_TIME	On Line