This cube dimension represents sales person and is based on the IFS Applications dimension COUNTER PART TWO. The dimension is normally based on Code Part K.All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Company Code | NO | Represents the Company Code of the dimension. |
Counter Part Two | NO | Key. Built as COMPANY+ ' - ' + CODE + ' - ' + DESCRIPTION |
Counter Part Code Desc | NO | Represents the CODE + Description of the dimension. |
Counter Part Two Code | NO | Represents the CODE of the dimension. |
Counter Part Two Desc | NO | Represents the Description of the dimension. |
CounterPartTwoHy | YES | Hierarchy consisting of levels -Company Code -Counter Part Two Code Desc |
Cube Name |
GENERAL LEDGER |
BI Access View | BI Component | Recommended Source Type |
DIM_COUNTER_PART_TWO_BI | ACCRDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.161 Load IFSAppl_DIM_COUNTER_PART_TWO_BI.dtsx | IFSAppl_DIM_COUNTER_PART_TWO_BI |
T - DW | 2.1.161 Load Dw_DIM_COUNTER_PART_TWO.dtsx | Dw_DIM_COUNTER_PART_TWO |
L - DM | 3.1.161 Load Dm_DIM_COUNTER_PART_TWO.dtsx | Dm_DIM_COUNTER_PART_TWO |