Model: Incident Analysis - Specifications for Dimension Table: REPORTING PERIOD
Attributes
| Attribute |
Description (where applicable) |
| Current Month Flag |
|
| Current Year Flag |
|
| Last 12 Months Flag |
|
| Last 24 Months Flag |
|
| Previous Month Flag |
|
| Previous Year Flag |
|
| Reporting Date |
The REPORTING_DATE without a time stamp. |
| Reporting Date String |
|
| Reporting Month |
|
| Reporting Month No |
|
| Reporting Month Short |
|
| Reporting Quarter |
|
| Reporting Week |
|
| Reporting Weekday |
|
| Reporting Weekday No |
|
| Reporting Year |
The reporting year associated with Company and Reporting Date (RPD_YEAR) |
| Reporting Year Month |
|
| Year (Week based) |
|
| Hierarchy |
Level |
| ReportingDateMFHy |
|
|
Reporting Year |
|
Reporting Quarter |
|
Reporting Month |
|
Reporting Date |
| ReportingDateMSHy |
|
|
Reporting Year |
|
Reporting Quarter |
|
Reporting Month |
| ReportingDateWFHy |
|
|
Year (Week based) |
|
Reporting Week |
|
Reporting Date |
| ReportingDateWSHy |
|
|
Year (Week based) |
|
Reporting 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 |
| REPORTING PERIOD |
DIM_BI_TIME_BI |
DIM_BI_TIME_BI |
DIM_BI_TIME |
On Line |