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 |