Model: CRM - Specifications for Dimension Table: DIM_RPD_COMPANY_PERIOD
Attributes
| Attribute |
Description (where applicable) |
| ACCOUNTING_DATE |
Not Required |
| ALT_DIM_ID |
Not Required |
| ALT_DIM_ID_WITH_RPD_ID |
Not Required |
| CODE |
Not Required |
| COMPANY |
Not Required |
| FROM_DATE |
Not Required |
| ID |
Not Required |
| ID_WITH_RPD_ID |
Not Required |
| NUMBER_ATTRIBUTE1 |
Not Required |
| NUMBER_ATTRIBUTE2 |
Not Required |
| NUMBER_ATTRIBUTE3 |
Not Required |
| NUMBER_ATTRIBUTE4 |
Not Required |
| NUMBER_ATTRIBUTE5 |
Not Required |
| REPORTING_DATE |
Not Required |
| RPD_ID |
Not Required |
| RPD_ID_DESCRIPTION |
Not Required |
| RPD_PERIOD |
Not Required |
| RPD_YEAR |
Not Required |
| STRING_ATTRIBUTE1 |
Not Required |
| STRING_ATTRIBUTE2 |
Not Required |
| STRING_ATTRIBUTE3 |
Not Required |
| STRING_ATTRIBUTE4 |
Not Required |
| STRING_ATTRIBUTE5 |
Not Required |
| UNTIL_DATE |
Not Required |
| YEAR_PERIOD_NUM |
Not Required |
| YEAR_PERIOD_STR |
Not Required |
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 |
| DIM_RPD_COMPANY_PERIOD |
DIM_RPD_COMPANY_PERIOD_BI |
DIM_RPD_COMPANY_PERIOD_BI |
DIM_RPD_COMPANY_PERIOD |
On Line |