Cube Dimension - Fault Type

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

ATTRIBUTES

Attribute Hierarchy Description
Fault Type NO Key. Built as DESCR i.e. the description of the work order fault type (CODE)
Fault Type Code NO Represents the ERR_TYPE  (also equal to CODE), i.e. work order fault type

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_FAULT_TYPE_BI WODI Data Mart

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.069 Load IFSAppl_DIM_FAULT_TYPE_BI.dtsx IFSAppl_DIM_FAULT_TYPE_BI
T - DW 2.1.069 Load Dw_DIM_FAULT_TYPE.dtsx Dw_DIM_FAULT_TYPE
L - DM 3.1.069 Load Dm_DIM_FAULT_TYPE.dtsx Dm_DIM_FAULT_TYPE