Model: Project - Specifications for Dimension Table: CUT OFF DATE
Attributes
| Attribute |
Description (where applicable) |
| Cut Off Date | Cut Off Date |
| Cut Off Year | Cut off year |
| Cut Off Quarter | Quarter, not NLS dependent |
| 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 Week No | Week Number |
| Cut Off Weekday | Week Day |
| Cut Off Weekday No | Week Day Number |
| Cut Off 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 |
| 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)
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 |
| CUT OFF DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |