CUBE DIMENSION - Work Stage

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

ATTRIBUTES

Attribute Hierarchy Description
Work Stage ID NO Key. WORK_STAGE_ID
Work Stage ID Code NO The CODE of the dimension, i.e. WORK_STAGE_ID (same as CODE)

USED BY CUBE

Cube Name
MAINTENANCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_WORK_STAGE_BI PM On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.039 Load IFSAppl_WORK_STAGE_BI.dtsx IFSAppl_DIM_WORK_STAGE_BI
T - DW 2.1.039 Load Dw_DIM_WORK_STAGE.dtsx Dw_DIM_WORK_STAGE
L - DM 3.1.039 Load Dm_DIM_WORK_STAGE.dtsx Dm_DIM_WORK_STAGE