This cube dimension represents work location information in HR based on the IFS Applications dimension DIM_WORK_LOCATION. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Work Location | NO | Key. Displayed as CODE + ' - ' + WORK_LOCATION_DESCRIPTION |
Work Location Code | NO | Work location code e.g. company office |
Work Location Description | NO | Description of work location |
Cube Name |
PROJECT |
BI Access View | BI Component | Recommended Source Type |
DIM_WORK_LOCATION_BI | PERSDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.125 Load IFSAppl_DIM_WORK_LOCATION_BI | IFSAppl_DIM_WORK_LOCATION_BI |
T - DW | 2.1.125 Load Dw_DIM_WORK_LOCATION | Dw_DIM_WORK_LOCATION |
L - DM | 3.1.125 Load Dm_DIM_WORK_LOCATION | Dm_DIM_WORK_LOCATION |