Cube Dimension - Company Reporting Period

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

ATTRIBUTES

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"

USED BY CUBE

Cube Name
MAINTENANCE
MANUFACTURING
PROCUREMENT
PROJECT
SALES

ETL Information

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