Model: CRM - Specifications for Dimension Table: DUE DATE
Attributes
| Attribute |
Description (where applicable) |
| Current Month Flag |
Not Needed |
| Current Year Flag |
Not Needed |
| ID |
Not Needed |
| Last 12 Months Flag |
Not Needed |
| Last 24 Months Flag |
Not Needed |
| Previous Month Flag |
Not Needed |
| Previous Year Flag |
Not Needed |
| Reporting Date |
Not Needed |
| Reporting Date String |
Not Needed |
| Reporting Day of Month |
Not Needed |
| Reporting Month |
Not Needed |
| Reporting Month No |
Not Needed |
| Reporting Month Short |
Not Needed |
| Reporting Quarter |
Not Needed |
| Reporting Week |
Not Needed |
| Reporting Weekday |
Not Needed |
| Reporting Weekday No |
Not Needed |
| Reporting Year |
Not Needed |
| Reporting Year Month |
Not Needed |
| Year (Week based) |
Not Needed |
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 |
| DUE DATE |
DIM_BI_TIME_BI |
DIM_BI_TIME_BI |
DIM_BI_TIME |
On Line |