Model: Project - Specifications for Dimension Table: PROJ START DATE
Attributes
| Attribute |
Description (where applicable) |
| 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 | |
| Proj Start Date | Project Start Date |
| Proj Start Date String | Date as string, fixed format, not NLS dependent |
| Proj Start Month | Project Start Month |
| Proj Start Month No | Project Start Month Number |
| Proj Start Month Short | Month short, 3 char, NLS dependent |
| Proj Start Quarter | Quarter, not NLS dependent |
| Proj Start Week No | Week Number |
| Proj Start Weekday | Week Day |
| Proj Start Weekday No | Week Day Number |
| Proj Start Year | Year, NLS dependent |
| Proj Start Year Month | Year month |
| Year (Week based) | Year, NLS dependent |
| Hierarchy |
Level |
| ProjStartMFHy | |
| Proj Start Year |
| Proj Start Quarter |
| Proj Start Month |
| Proj Start Date |
| ProjStartMSHy | |
| Proj Start Year |
| Proj Start Quarter |
| Proj Start Month |
| ProjStartWFHy | |
| Proj Start Year |
| Proj Start Week No |
| Proj Start Date |
| ProjStartWSHy | |
| Proj Start Year |
| Proj Start 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 |
| PROJ START DATE | DIM_BI_TIME_TM | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |