Model: CRM - Specifications for Dimension Table: REPORTING_PERIOD_CRM
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 Desc | 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 Year Period | The reporting year (RPD_YEAR) and period (RPD_PERIOD), associated
with Company and Reporting Date, concatenated as a number in the format YYYYMM |
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_CRM | DIM_REPORTING_PERIOD_CRM_TM | DIM_RDP_COMPANY_PERIOD_BI, | DIM_RDP_COMPANY_PERIOD, LUP_REPORTING_PERIOD_TC | On Line |