Model: Production Performance - Specifications for Dimension Table: LAST ACTIVITY DATE
Attributes
| Attribute |
Description (where applicable) |
| Current Month Flag |
|
| Current Year Flag |
|
| ID |
|
| Last 12 Months Flag |
|
| Last 24 Months Flag |
|
| Last Activity Date |
|
| Last Activity Date String |
|
| Last Activity Day of Month |
|
| Last Activity Month |
|
| Last Activity Month No |
|
| Last Activity Month Short |
|
| Last Activity Quarter |
|
| Last Activity Week |
|
| Last Activity Weekday |
|
| Last Activity Weekday No |
|
| Last Activity Year |
|
| Last Activity Year Month |
|
| Previous Month Flag |
|
| Previous Year Flag |
|
| Year (Week based) |
|
| Hierarchy |
Level |
| LastActDateMFHy |
|
|
Last Activity Year |
|
Last Activity Quarter |
|
Last Activity Month |
|
Last Activity Date |
| LastActDateMSHy |
|
|
Last Activity Year |
|
Last Activity Quarter |
|
Last Activity Month |
| LastActDateWFHy |
|
|
Year (Week based) |
|
Last Activity Week |
|
Last Activity Date |
| LastActDateWSHy |
|
|
Year (Week based) |
|
Last Activity 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 |
| LAST ACTIVITY DATE |
|
|
|
|