Model: Project - Specifications for 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 |
| 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)
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 |