Model: Group Consolidation - Specifications for Dimension Table: REPORTING PERIOD
Attributes
| Attribute | Description (where applicable) |
| Company | The company identity. |
| Company-Date | Defined as the COMPANY + ' - ' + REPORTING DATE |
| Reporting Date | The REPORTING_DATE without a time stamp. |
| Reporting Period Descr | The description of the reporting period associated with
Company and Reporting Date (RPD_ID_DESCRIPTION) |
| Reporting Period No | The reporting period (number) associated with Company and
Reporting Date (RPD_PERIOD) |
| Reporting Year | The reporting year associated with Company and Reporting
Date (RPD_YEAR) |
| Reporting YearPeriod | The reporting year (RPD_YEAR) and period (RPD_PERIOD), associated
with Company and Reporting Date, concatenated as a number in the format YYYYMM |
| Hierarchy | Level |
| RepPeriodFHy | |
| Reporting Year |
| Reporting Period No |
| Reporting Date |
| Company-Date |
| RepPeriodSHy | |
| Reporting Year |
| Reporting Period No |
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_REPORTING_PERIOD_GC_TM, alt DIM_BI_TIME_BI combined with DIM_RDP_COMPANY_PERIOD_BI to DIM_BI_TIME_TM | DIM_RDP_COMPANY_PERIOD_BI | DIM_RPD_COMPANY_PERIOD | On Line |