Cube Dimension - Work Location

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.

ATTRIBUTES

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

USED BY CUBE

Cube Name
PROJECT

ETL Information

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