This cube dimension represents company 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. Reporting periods are defined per "product" area, meaning that e.g. the Maintenance cube is using periods related to one specific reporting period identity. The identity that applies is defined via configurations.
Natural keys in core dimension: RPD_ID, COMPANY, REPORTING_DATE
Attribute | Hierarchy | Description |
Company | NO | The company identity. |
Company-Date | NO | Key. Defined as the ID of the core dimension, i.e. a technical key, defined as the string "<Company>^<Reporting Date>" |
Reporting Date | NO | The REPORTING_DATE as a string in format "YYYY-MM-DD" |
Reporting Period Descr | NO | The description of the reporting period associated with Company and Reporting Date (RPD_ID_DESCRIPTION) |
Reporting Period No | NO | The reporting period (number) associated with Company and Reporting Date (RPD_PERIOD) |
Reporting Year | NO | The reporting year associated with Company and Reporting Date (RPD_YEAR) |
Reporting YearPeriod | NO | The reporting year (RPD_YEAR) and period (RPD_PERIOD), associated with Company and Reporting Date, concatenated as a number in the format "YYYYMM" |
Hierarchy | YES | Defined as "Company" -> "Reporting Year" -> "Reporting Period No" -> "Reporting Date" -> "Company-Date" |
PeriodHierarchy | YES | Defined as "Company" -> "Reporting Year" -> "Reporting Period No" |
Cube Name |
MAINTENANCE |
MANUFACTURING |
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 |