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 |