Model: Group Reporting - Specifications for Dimension Table: COUNTERPART ONE
Attributes
| Attribute |
Description (where applicable) |
| Company |
Natural parent, Company |
| Company Counterpart One |
Defined as COMPANY + ' - ' +CODE + ' - ' + DESCRIPTION |
| Counterpart One |
Defined as CODE + ' - ' + DESCRIPTION |
| Counterpart One Code |
Counter Part One Code |
| Counterpart One Descr |
Counter Part One Description |
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 |
| COUNTERPART ONE |
DIM_COUNTER_PART_ONE_GR_TM |
DIM_COUNTER_PART_ONE_BI |
DIM_COUNTER_PART_ONE |
On Line |