Model: Production Performance - Specifications for Dimension Table: CONFIRMED DATE

On this page you will find the specifications regarding the Model: Production Performance and Dimension Table: CONFIRMED DATE.

Attributes

Attribute	Description (where applicable)
Confirmed Date
Confirmed Date String
Confirmed Day of Month
Confirmed Month
Confirmed Month No
Confirmed Month Short
Confirmed Quarter
Confirmed Week
Confirmed Weekday
Confirmed Weekday No
Confirmed Year
Confirmed Year Month
Current Month Flag
Current Year Flag
ID
Last 12 Months Flag
Last 24 Months Flag
Previous Month Flag
Previous Year Flag
Year (Week based)

Hierarchies

Hierarchy	Level
ConfDateMFHy
	Confirmed Year
	Confirmed Quarter
	Confirmed Month
	Confirmed Date
ConfDateMSHy
	Confirmed Year
	Confirmed Quarter
	Confirmed Month
ConfDateWFHy
	Year (Week based)
	Confirmed Week
	Confirmed Date
ConfDateWSHy
	Year (Week based)
	Confirmed Week

USED BY MODEL(S)

Model Name

Production Performance

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
CONFIRMED DATE