Model: CRM - Specifications for Dimension Table: DUE DATE

On this page you will find the specifications regarding the Model: CRM and Dimension Table: DUE DATE.

Attributes

AttributeDescription (where applicable)
Current Month FlagNot Needed
Current Year FlagNot Needed
IDNot Needed
Last 12 Months FlagNot Needed
Last 24 Months FlagNot Needed
Previous Month FlagNot Needed
Previous Year FlagNot Needed
Reporting DateNot Needed
Reporting Date StringNot Needed
Reporting Day of MonthNot Needed
Reporting MonthNot Needed
Reporting Month NoNot Needed
Reporting Month ShortNot Needed
Reporting QuarterNot Needed
Reporting WeekNot Needed
Reporting WeekdayNot Needed
Reporting Weekday NoNot Needed
Reporting YearNot Needed
Reporting Year MonthNot Needed
Year (Week based)Not Needed

USED BY MODEL(S)

Model Name
CRM

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 TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
DUE DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line