This cube dimension represents reporting periods and is based on the IFS Applications dimension DIM_RPD_COMPANY_PERIOD. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural keys are RPD_ID, COMPANY, REPORTING_DATE
| Attribute | Hierarchy | Description |
| Company | NO | The company identity. |
| Company-Date | NO | Key. Defined as the ID, i.e. a technical key. |
| Reporting Date | NO | The REPORTING_DATE as a string in format 'YYYY-MM-DD' |
| Reporting Period Descr | NO | The description of the reporting period definition (RPD_ID_DESCRIPTION) |
| Reporting Period No | NO | The reporting period number. (RPD_PERIOD) |
| Reporting Year | NO | The reporting year (RPD_YEAR) |
| Reporting YearPeriod | NO | The concatenated value of year (RPD_YEAR) and period (RPD_PERIOD) as a number |
| Hierarchy | YES | Defined as "Company" -> "Reporting Year" -> "Reporting Period No" -> "Reporting Date" |
| PeriodHierarchy | YES | Defined as "Company" -> "Reporting Year" -> "Reporting Period No" |
| Cube Name |
| MAINTENENCE |
| PROCUREMENT |
| PROJECT |
| SALES |
| BI Access View | BI Component | Recommended Source Type |
| DIM_RPD_COMPANY_PERIOD_BI | ACCRDI | On Line |
| ETL Step | File Name of SSIS Package | Table Name |
| E - Stage | 1.1.019 Load IFSAppl_DIM_COMPANY_REPORTING_PERIOD_BI.dtsx | IFSAppl_DIM_COMPANY_REPORTING_PERIOD_BI |
| T - DW | 2.1.019 Load Dw_DIM_COMPANY_REPORTING_PERIOD.dtsx | Dw_DIM_COMPANY_REPORTING_PERIOD |
| L - DM | 3.1.019 Load Dm_DIM_COMPANY_REPORTING_PERIOD.dtsx | Dm_DIM_COMPANY_REPORTING_PERIOD |