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