Model: Production Performance - Specifications for Dimension Table: COMPLETED DATE
Attributes
| Attribute |
Description (where applicable) |
| Completed Date |
|
| Completed Date String |
|
| Completed Day of Month |
|
| Completed Month |
|
| Completed Month No |
|
| Completed Month Short |
|
| Completed Quarter |
|
| Completed Week |
|
| Completed Weekday |
|
| Completed Weekday No |
|
| Completed Year |
|
| Completed Year Month |
|
| Current Month Flag |
|
| Current Year Flag |
|
| Last 12 Months Flag |
|
| Last 24 Months Flag |
|
| Previous Month Flag |
|
| Previous Year Flag |
|
| Year (Week based) |
|
| Hierarchy |
Level |
| ComplDateMFHy |
|
|
Completed Year |
|
Completed Quarter |
|
Completed Month |
|
Completed Date |
| ComplDateMSHy |
|
|
Completed Year |
|
Completed Quarter |
|
Completed Month |
| ComplDateWFHy |
|
|
Year (Week based) |
|
Completed Week |
|
Completed Date |
| ComplDateWSHy |
|
|
Year (Week based) |
|
Completed Week |
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 |
| COMPLETED DATE |
|
|
|
|