Cube Dimension - Work Type

This cube dimension represents the work type and is based on the IFS Applications dimension DIM_WORK_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Work Type NO Key. Built as CODE + ' - ' + DESCR
Work Type Code NO The dimension CODE, i.e. work type
Work Type Descr NO The work type descriptopn (DESCR)

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_WORK_TYPE_BI PCMSDI Data Mart

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.041 Load IFSAppl_DIM_WORK_TYPE_BI.dtsx IFSAppl_DIM_WORK_TYPE_BI
T - DW 2.1.041 Load Dw_DIM_WORK_TYPE.dtsx Dw_DIM_WORK_TYPE
L - DM 3.1.041 Load Dm_DIM_WORK_TYPE.dtsx Dm_DIM_WORK_TYPE